Differences
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]] | ||
