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 IMMEDIATE


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


Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL

The EXECUTE IMMEDIATE StatementMethod 1 parses, then immediately executes the SQL statement using the EXECUTE IMMEDIATE command … to be executed, which cannot be a query. The syntax of the EXECUTE IMMEDIATE statement follows … : EXEC SQL EXECUTE IMMEDIATE {:HOST-STRING | STRING-LITERAL }END-EXEC. In the following example, you use … text of a SQL statement EXEC

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

Use of EXECUTE IMMEDIATEPurpose The EXECUTE IMMEDIATE statement executes a literal or host variable character string … : Syntax EXEC SQL EXECUTE IMMEDIATE [:]sql_statement END-EXEC. Variable Only one variable is available … with the EXECUTE IMMEDIATE statement. sql_statement The sql_statement variable is the SQL statement … or PL/SQL block in a character

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

Use of EXECUTE IMMEDIATEIMMEDIATE {:sql_statement | string_literal} Variable sql_statement The SQL statement or PL/SQL block … in a character string. Example EXEC SQL EXECUTE IMMEDIATE:statement;

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 18 of 52

EXECUTE IMMEDIATE StatementThe EXECUTE IMMEDIATE statement prepares (parses) and immediately executes a dynamic SQL statement

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Directives

EXECUTE IMMEDIATE (Executable Embedded SQL)an EXECUTE IMMEDIATE statement, Oracle parses the specified SQL statement or PL/SQL block, checking … Chapter 14, "ANSI Dynamic SQL". Example This example illustrates the use of the EXECUTE IMMEDIATE … statement: EXEC SQL EXECUTE IMMEDIATE 'DELETE FROM emp WHERE empno = 9460'. Related Topics EXECUTE

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Using the EXECUTE IMMEDIATE StatementThe EXECUTE IMMEDIATE statement prepares (parses) and immediately executes a dynamic SQL statement … or an anonymous PL/SQL block. The syntax is EXECUTE IMMEDIATE dynamic_string [INTO {define_variable … overhead because EXECUTE IMMEDIATE re-prepares the dynamic string before every execution.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Using the EXECUTE IMMEDIATE StatementUsing the OPEN-FOR, FETCH, and CLOSE Statements

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Precompiler Directives

EXECUTE IMMEDIATE (Executable Embedded SQL)Notes When you issue an EXECUTE IMMEDIATE statement, Oracle9 i parses the specified SQL statement or PL … IMMEDIATE Statement". Example This example illustrates the use of the EXECUTE IMMEDIATE statement: EXEC … SQL EXECUTE IMMEDIATE 'DELETE FROM EMP WHERE EMPNO = 9460' END-EXEC. Related Topics PREPARE

Administrator's Guide, 9i Release 2 (9.2.0.2)

Starting Up and Shutting Down

Shutting Down with the IMMEDIATE OptionUse immediate database shutdown only in the following situations: To initiate an automated and … unable to log off To shut down a database immediately, use the SHUTDOWN command with the IMMEDIATE option … : SHUTDOWN IMMEDIATE Immediate database shutdown proceeds with the following conditions: No new

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Using Dynamic SQL

The EXECUTE IMMEDIATE StatementMethod 1 parses, then immediately executes the SQL statement using the EXECUTE IMMEDIATE command … to be executed, which cannot be a query. The syntax of the EXECUTE IMMEDIATE statement follows:

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Embedded SQL Commands and Directives

EXECUTE IMMEDIATE (Executable Embedded SQL)Purpose To prepare and execute a DELETE, INSERT, or UPDATE statement or a PL/SQL block containing no host variables.

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

IDENTIFIEDIMMEDIATE * IN *

Data Guard Broker, 9i Release 2 (9.2.0.2)

Data Guard Command-Line Interface Reference

FormatSHUTDOWN [ ABORT | IMMEDIATE | NORMAL ];

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

EXCEPTION_INIT PragmaExceptions EXECUTE IMMEDIATE Statement

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01145 offline immediate disallowed unless media recovery enabledCause: ALTER TABLESPACE... OFFLINE IMMEDIATE or ALTER DATABASE DATAFILE... OFFLINE is only

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01089 immediate shutdown in progress - no operations are permittedCause: The SHUTDOWN IMMEDIATE command was used to shut down a running Oracle instance, terminating

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-16042 user requested cancel immediate of managed recovery operationCause: The managed standby database recovery operation has been canceled immediately per user request. Processing of the current archive log file has been interrupted and therefore the database is in an inconsistent state. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-25201 invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATECause: An invalid value specified for parameter VISIBILITY. Action: Specify either ON_COMMIT or IMMEDIATE.

Error Messages, 9i Release 2 (9.2.0.2)

DBNEWID Messages (NID)

NID-00122 Database should have no offline immediate datafilesCause: The database has one or more datafiles that are in OFFLINE IMMEDIATE mode. Action: Drop the datafiles or recover them and bring them online.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_DEBUG, 2 of 2

SyntaxDBMS_DEBUG.DEBUG_ON ( no_client_side_plsql_engine BOOLEAN:= TRUE, immediate BOOLEAN:= FALSE);