PL/SQL API jcs.search
Summary
Given a filehandle (and optionally a starting-line) find the first line which matches the given pattern.
The same wild-card characters can be used as in SQL's LIKE operator: '%' matches any number of characters (including zero) and '_' matches exactly one character.
Lines longer than 2000 characters are silently truncated if the readmode is not binary.
Specification
function search(fhandle in number,
pattern in varchar2,
beginline in number default 1,
flags in number default 0)
return number
Parameters
- fhandle - the filehandle
- pattern - search pattern
- beginline - line to start the search for the pattern on
- flags - modification flags on how to perform the search; sum of zero or more of the following values:
- jcs.search_ignorecase: ignore upper/lowercase differences
- jcs.search_entireword: search string must be separated by spaces or tabs
- jcs.search_reversedir: search up, not down
- jcs.search_nowildcard: switches off the LIKE scanning, removing special meaning from % (procent) and _ (underscore)
- returns number -
Transaction keyword
The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.
network_agent
See Also
plsqlTopic
onsiteTopic