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 OPEN


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


Release 1.8, 10g Release 1 (10.1)

Using Dynamic SQL

OPENPREPARE sql_stmt FROM:delete_stmt; EXEC SQL DECLARE dept_cursor FOR sql_stmt; when you OPEN … select_stmt. OPEN OPEN allocates an Oracle cursor, binds input host variables, and executes the query … , identifying its active set. OPEN also positions the cursor on the first row in the active set and

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Blob Cl a ss

open()Opens the BLOB in read/write or read-only mode. Syntax void open( LobOpenMode mode

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Clob Class

open()Opens the CLOB in read/write or read-only mode. Syntax void open( LObOpenMode mode

Reference, 10g Release 1 (10.1)

ORDSource Methods

open( )Format open(userArg IN RAW, ctx OUT RAW) RETURN INTEGER; Description Opens a data source. It is

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Bfile Class

open()Opens an existing BFILE for read-only access. This function is meaningful the first time it is called for a Bfile object. Syntax void open();

User's Guide and Reference, 10g Release 1 (10.1)

OPEN Statement

OPEN StatementThe OPEN statement executes the query associated with a cursor. It allocates database resources to … open. cursor_parameter_name A variable declared as the formal parameter of a cursor. (For the syntax … OPEN statement is executed. The FETCH statement retrieves the rows. With a FOR UPDATE cursor, the rows … parameter in the cursor

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

45 DBMS_LOB

OPEN ProcedureThis procedure opens a LOB, internal or external, in the indicated mode. Valid modes include read-only, and read/write.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

13 Oracle Dynamic SQL

13.9.3 OPENOPEN allocates an Oracle cursor, binds input host variables, and executes the query, identifying … its active set. OPEN also positions the cursor on the first row in the active set and zeroes the rows … , OPEN allocates emp_cursor and assigns the host variable salary to the WHERE clause, as follows: EXEC SQL OPEN emp_cursor

DML Reference, 10g Release 1 (10.1)

SQL

SQL OPENThe SQL OPEN command activates an explicitly-declared SQL cursor. When the cursor is opened, SQL … cursor's result set, and leaves the cursor in the open state for use by SQL FETCH or SQL IMPORT. The … cursor is positioned before the first row of the result set. Syntax SQL OPEN  cursor Arguments

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

file openThe time it takes to open the file.

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

13 Large Objects (LOBs)

13.4.14 OPENPurpose Open a LOB or BFILE for read or read/write access. Syntax EXEC SQL [AT [:]database] LOB … OPEN:src [ READ ONLY | READ WRITE ] END-EXEC. Host Variables src (IN OUT) LOB locator of the LOB or … internal LOBs, being OPEN is associated with the LOB, not with the locator. Assigning an already … the same LOB. For BFILEs, being

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

25 DBMS_DATAPUMP

OPEN FunctionThis function is used to declare a new job using the Data Pump API. The handle that is returned is used as a parameter for calls to all other procedures except ATTACH.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

16 Large Objects (LOBs)

16.4.14 OPENPurpose Open a LOB or BFILE for read or read/write access. Syntax EXEC SQL [AT [:]database] LOB … OPEN:src [ READ ONLY | READ WRITE ]. Host Variables src (IN OUT) LOB locator of the LOB or BFILE … LOBs, being OPEN is associated with the LOB, not the locator. Assigning an already OPENed locator … . For BFILEs, being OPEN

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

BFILE openThe session waits for an external large object (LOB) to open. Wait Time: The total elapsed time for

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

50 DBMS_METADATA

OPEN ProcedureThis procedure specifies the type of object to be retrieved, the version of its metadata, and the object model. The return value is an opaque context handle for the set of objects to be used in subsequent calls. See Also: For more information about related subprograms: Subprograms for Retrieval of Multiple Objects from the Database

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

9 Oracle Dynamic SQL

9.11.3 OPENThe OPEN statement allocates a cursor, binds input host variables, and executes the query … , identifying its active set. OPEN also positions the cursor on the first row in the active set and zeroes the … example, OPEN allocates EMPCURSOR and assigns the host variable SALARY to the WHERE clause, as follows: EXEC SQL OPEN

User's Guide and Reference, 10g Release 1 (10.1)

OPEN-FOR-USING Statement

OPEN-FOR-USING StatementThe OPEN-FOR-USING statement associates a cursor variable with a query, executes the query … the OPEN-FOR-USING statement when building a query where you know the WHERE clauses in advance. Use … the OPEN-FOR statement when you need the flexibility to process a dynamic query with an unknown … Notes You use three statements to process

User's Guide and Reference, 10g Release 1 (10.1)

OPEN-FOR Statement

OPEN-FOR StatementThe OPEN-FOR statement executes the query associated with a cursor variable. It allocates database … . To open the host cursor variable, you can pass it as a bind variable to an anonymous PL/SQL block … . You can reduce network traffic by grouping OPEN-FOR statements. For example, the following PL/SQL … */ BEGIN OPEN:emp_cv

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

global cache open sThe session waits for a resource get in SHARED mode on the block identified by file# and block#. Wait Time: 1 second Parameter Description file# See "file#" block# See "block#" class See "class"

Release 1.8, 10g Release 1 (10.1)

Meeting Program Requirements

Developing X/Open ApplicationsX/Open applications run in a distributed transaction processing (DTP) environment. In an abstract … model, an X/Open application calls on resource managers (RMs) to provide a variety of services. For