how to run sql query on clob column?

[dbase77]

Hi,

I have one table which contains clob column. How do I query this clob column? Very strange, normal query doesn't work at all.

Thanks all.

 

[Turkbear]

Hi,
Try this thread:

thread759-1535086



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

DBase77,

Can you post your problematic query? You should be able to query against a CLOB column in the same fashion as a VARCHAR column.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”