You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for INSTR


1 to 20 of 62 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

INSTR

INSTRThe 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

SQL Reference, 10g Release 1 (10.1)

INSTR

INSTRSyntax 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

DML Reference, 10g Release 1 (10.1)

INSTR

stringINSTR 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

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

INSTR FunctionThis function returns the matching position of the nth occurrence of the pattern in the LOB, starting from the offset you specify.

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Pragmaspragma restrict_references(INSTR, WNDS, WNPS, RNDS, RNPS);

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-32766: instr with negative offset: use varchar semantics on LOBsCause: None Action: Facilitate debugging and testing ORA-32766: instr with negative offset: use varchar semantics on LOBs

Globalization Support Guide, 10g Release 1 (10.1)

What's New in Globalization Support?

Regular Expressions, REPLACE, and INSTR. This implementation supports multilingual queries and is locale-sensitive. See

DML Reference, 10g Release 1 (10.1)

15 INF_STOP_ON_ERROR to LIKEESCAPE

15 INF_STOP_ON_ERROR to LIKEESCAPEINSTAT INSTR INSTRB INTPART IRR ISDATE ISVALUE JOINBYTES JOINCHARS JOINCOLS JOINLINES KEY LAG LAGABSPCT

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Return ValuesTable 45-36 INSTR Function Return Values Return Description INTEGER Offset of the start of the

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

9 SQL Semantics and LOBs

UNICODE SupportVariations on the INSTR, SUBSTR, LENGTH, and LIKE functions are provided for Unicode support

Globalization Support Guide, 10g Release 1 (10.1)

7 Programming with Unicode

Other SQL Functionsthe 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

Oracle® XML Developer's Kit Programmer's Guide, 10g Release 1 (10.1)

24 XSU for PL/SQL

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;

DML Reference, 10g Release 1 (10.1)

INSTRB

INSTRBsubstring using characters, use INSTR. Return Value A nonzero INTEGER when the search is successful or

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

13 Data Interface for Persistent LOBs

Passing CLOBs to SQL and PL/SQL Built-In Functionsdata. For example, INSTR can accept a CLOB as well as other character data. Any SQL or PL/SQL built-in

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

ExceptionsTable 45-37 INSTR Function Exceptions for BFILES Exception Description UNOPENED_FILE File was not

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

9 SQL Semantics and LOBs

WHERE Clause Usage with LOBs* from t where substr(c, 1, 2) like '%b%'; select * from t where instr(c, 'b') = 2;

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

ParametersTable 45-35 INSTR Function Parameters Parameter Description lob_loc Locator for the LOB to be

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Usage Notesto succeed. Operations that accept RAW or VARCHAR2 parameters for pattern matching, such as INSTR, do

Globalization Support Guide, 10g Release 1 (10.1)

9 SQL and PL/SQL Programming in a Global Environment

SQL Functions for Different Length Semanticsthree 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

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

A LOB Demonstration Files

Java LOB Demonstration Filesif 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