position(String searchstr, long start)

Syntax:

long position(String searchstr, long start) throws SQLException

Description:

Retrieves the character position at which the specified substring searchstr appears in the SQL CLOB value represented by this Clob object. The search begins at position start.

Parameters:

searchstr

Type: String 

the substring for which to search

start

the position at which to begin searching; the first position is 1

Returns:

the position at which the substring appears or -1 if it is not present; the first position is 1

Throws:

SQLException - if a database access error occurs, start < 1, or searchstr is null

Reference:

For more information, reference JDBC documentation for: Clob.position(String, long)