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.