SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select statement using a wildcard on a clob in the where clause

630617May 29 2008 — edited May 29 2008

Hi All,

How can I form a select statement usign a wildcard on a CLOB in the where clause. I cant seem to find much information on this. I.e.

SELECT * FROM MYTABLE WHERE CLOB_COLUMN LIKE '% SEARCH_STRING%'

Ive tried using TO_CHAR but I get an inconsistent data type error message.

any help would be greatly appreciated. Thanks in advance.

Message was edited by:
Hoodlywood

Message was edited by:
Hoodlywood

Message was edited by:
Hoodlywood

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2008

Added on May 29 2008

2 comments

1,097 views