CONTAINS « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. CONTAINS
1.CONTAINS(description, '10g near oracle') > 0
2.CONTAINS(description, 'website') > 3
3.Proximity searches with contains
4.Test case-insensitivity with a simple mixed-case query