problem in accessing lob/long columns

problem in accessing lob/long columns

 

  




plz tell how to access the content of a long column or
CLOB of LOB type. i.e searching based on string critera.

for e.g where ename like '%oracle'.
how can we do it for long or lob columns in sql or pl/sql?

by madhu





_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

Oracle LazyDBA home page