| Oracle 9i and the Text datatype [message #49857] |
Thu, 14 February 2002 04:49  |
Hughes
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
We've experienced trouble querying on fields that use a CLOB data type in 8i. Fortunately, we are upgrading to 9i and looking to use the Text data type in place of the CLOB data type. Is the Text data type more flexible in terms of the queries? My hope is that it works similar to a Text data type in SQL Server, where I can simply perform a "like" in the SQL statement.
Any info is greatly appreciated.
|
|
|
|
| Re: Oracle 9i and the Text datatype [message #49893 is a reply to message #49857] |
Fri, 15 February 2002 20:05  |
nash
Messages: 10
Registered: February 2002
|
Junior Member |
|
|
Hi Hughes,
I am using both SQLServer & Oracle. Oracle does not have a datatype called TEXT similar to SQLServer. You have to continue to use CLOB. I believe your reference to Text in Oracle means Oracle Text which is different.
Hope this helps.
Nash
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
