This shows you the differences between two versions of the page.
— |
clob_partial_search [2014/10/25 21:52] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ==== Search for a pattern in an Oracle CLOB ==== | ||
+ | <code> | ||
+ | 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; | ||
+ | </code> | ||
+ | |||
+ | ---- | ||
+ | * [[databaseinfo|Back to Database]] | ||