Top

Name

strcontains — Performs substring search

Synopsis

strcontains ( in str string ,
  in sub string );
 

Description

strcontains performs a substring search, returning 1 or 0.

Parameters

str

String to search from.

sub

Substring to search for.

Return Types

1 if found, 0 if not found.

Examples

Example 24.415. Simple example

SQL> select strcontains('AbracadabrA','abrA');
strcontains
INTEGER
_______________________________________________________________________________

1

1 Rows. -- 0 msec.

SQL> select strcontains('AbracadabrA','XZ');
strcontains
INTEGER
_______________________________________________________________________________

0

1 Rows. -- 0 msec.