Search for a pattern in an Oracle CLOB

select column1, column2, column3, clob_column
  from table_with_clob
 where column1 = 12
   and column2 = 4
   and (
dbms_lob.instr(clob_field, 'pattern',1,1) > 0;

clob_partial_search.txt · Last modified: 2014/10/26 01:52 (external edit)
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0