Differences

This shows you the differences between two versions of the page.

Link to this comparison view

clob_partial_search [2014/10/26 01: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]]
  
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