How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
INSTR → The INSTR function searches a string for a substring using characters and returns the position in … the string that is the first character of a specified occurrence of the substring. INSTR calculates … using bytes, use INSTR. Return Value A nonzero INTEGER when the search is successful or 0 (zero) when … it is not. Syntax INSTR
INSTR → Syntax instr::= Description of the illustration instr.gif Purpose The INSTR functions search string … that is the first character of this occurrence. INSTR calculates strings using characters as defined … which the second occurrence of " OR " begins: SELECT INSTR('CORPORATE FLOOR','OR', 3, 2) "Instring … character
string → INSTR counts and searches backward from the end of string. The default value of position is 1, which … the position in "Corporate Floor" at which the second occurrence of "or" begins. SHOW INSTR … that this second occurrence begins with the second character in the search string. SHOW INSTR('Corporate Floor','or', -3, 2) 2
INSTR Function → This function returns the matching position of the nth occurrence of the pattern in the LOB, starting from the offset you specify.
Pragmas → pragma restrict_references(INSTR, WNDS, WNPS, RNDS, RNPS);
ORA-32766: instr with negative offset: use varchar semantics on LOBs → Cause: None Action: Facilitate debugging and testing ORA-32766: instr with negative offset: use varchar semantics on LOBs
Regular Expressions → , REPLACE, and INSTR. This implementation supports multilingual queries and is locale-sensitive. See
15 INF_STOP_ON_ERROR to LIKEESCAPE → INSTAT INSTR INSTRB INTPART IRR ISDATE ISVALUE JOINBYTES JOINCHARS JOINCOLS JOINLINES KEY LAG LAGABSPCT
Return Values → Table 45-36 INSTR Function Return Values Return Description INTEGER Offset of the start of the
UNICODE Support → Variations on the INSTR, SUBSTR, LENGTH, and LIKE functions are provided for Unicode support
Other SQL Functions → the customer table created in "SQL Functions for Unicode Datatypes". Example 7-4 INSTR Function … SELECT INSTR(name, N'Sm', 1, 1) FROM customers; Example 7-5 CONCAT Function SELECT CONCAT(name,id) FROM
XSU Generating XML Example 2: Printing CLOB to Output Buffer → := dbms_lob.SUBSTR(result,32767); loop exit when xmlstr is ; line:= substr(xmlstr,1,instr(xmlstr,chr(10 … ))-1); dbms_output.put_line('| '||line); xmlstr:= substr(xmlstr,instr(xmlstr,chr(10))+1); end loop; end;
INSTRB → substring using characters, use INSTR. Return Value A nonzero INTEGER when the search is successful or
Passing CLOBs to SQL and PL/SQL Built-In Functions → data. For example, INSTR can accept a CLOB as well as other character data. Any SQL or PL/SQL built-in
Exceptions → Table 45-37 INSTR Function Exceptions for BFILES Exception Description UNOPENED_FILE File was not
WHERE Clause Usage with LOBs → * from t where substr(c, 1, 2) like '%b%'; select * from t where instr(c, 'b') = 2;
Parameters → Table 45-35 INSTR Function Parameters Parameter Description lob_loc Locator for the LOB to be
Usage Notes → to succeed. Operations that accept RAW or VARCHAR2 parameters for pattern matching, such as INSTR, do
SQL Functions for Different Length Semantics → three groups of such SQL functions: SUBSTR, LENGTH, and INSTR. Each function in a group is based on a … requested portion of a substring. The LENGTH functions return the length of a string. The INSTR functions … characters and composed characters are counted as one character. The LENGTH and INSTR functions calculate … Also: Oracle
Java LOB Demonstration Files → if a pattern exists in a BFILE using instr Checking If a Pattern Exists in a BFILE Using INSTR … Initializing a LOB Locator Bind Variable linstr.java Seeing if pattern exists in LOB (instr) Patterns … : Checking for Patterns in a LOB Using INSTR lisopen.java Seeing if LOB is open Determining Whether a