| search a clob filed! [message #75899] |
Wed, 09 January 2002 21:01  |
Andre
Messages: 7
Registered: January 2002
|
Junior Member |
|
|
Hi!
I would like to do this:
select * from table where longtext like '%hello%';
In a vchar2 field it works perfect...in a "long" or
clob filed it dosenīt. How can i do that?
I spent many many hours, but couldīnt find a good solution.
Thanks for any help!!!!
Andre
|
|
|
|
|
|
|
|
| Re: search a clob filed! [message #75943 is a reply to message #75934] |
Tue, 30 April 2002 01:59  |
Abid Khan
Messages: 3
Registered: April 2002
|
Junior Member |
|
|
I assume you mean a clob field. And I am not sure if this has been answered yet.
Anyhow, try this :
SELECT resume FROM emp WHERE CONTAINS (resume, 'DBA') > 0;
If you need further help, contact me on my email.
Good luck!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
