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
Example24.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.