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.