Home » Server Options » Text & interMedia » search a clob filed!
search a clob filed! [message #75899] Wed, 09 January 2002 21:01 Go to next message
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 #75934 is a reply to message #75899] Fri, 22 March 2002 08:57 Go to previous messageGo to next message
Dustin
Messages: 4
Registered: March 2002
Junior Member
I've been strugling with the same problem, ever find the answer?
Re: search a clob filed! [message #75937 is a reply to message #75899] Thu, 04 April 2002 22:06 Go to previous messageGo to next message
Steffen Kraus
Messages: 1
Registered: April 2002
Junior Member
Here is a hint how to solve the problem:
http://lists.suse.com/archive/suse-oracle/2000-Oct/0084.html

CU Steffen

Re: search a clob filed! [message #75943 is a reply to message #75934] Tue, 30 April 2002 01:59 Go to previous messageGo to next message
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!
Re: search a clob filed! [message #75946 is a reply to message #75943] Tue, 07 May 2002 07:30 Go to previous message
Dave
Messages: 92
Registered: August 1999
Member
Does this work for case insensitive searches as well? I mean, can you add the upper() to it?
Previous Topic: Re: Querying on CLOB data type column
Next Topic: Re: DRG-51030: wildcard query expansion resulted in too many terms
Goto Forum:
  


Current Time: Fri Mar 29 07:45:23 CDT 2024