Results for IMMEDIATE


1 to 20 of 426 results. Prev  Next
Results per page:   20  | 40 | 60


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

EXECUTE IMMEDIATE Statement

EXECUTE IMMEDIATE StatementThe EXECUTE IMMEDIATE statement executes a dynamic SQL statement or anonymous PL/SQL block. You can … , because EXECUTE IMMEDIATE re-prepares the dynamic string before every execution. The string argument … to the EXECUTE IMMEDIATE command cannot be one of the national character types, such as NCHAR or … emp%ROWTYPE; BEGIN EXECUTE

Release 1.8, 10g Release 1 (10.1)

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:

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

9 Oracle Dynamic SQL

9.7.1 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*C/C++ Programmer's Guide, 10g Release 1 (10.1)

14 ANSI Dynamic SQL

14.5.9 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;

Release 1.8, 10g Release 1 (10.1)

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.

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

7 Performing SQL Operations with 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 main argument to EXECUTE IMMEDIATE is the string containing the … overhead because EXECUTE IMMEDIATE re-prepares the dynamic string before every execution. Example 7-1 Some … '; emp_rec emp%ROWTYPE;

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

10 ANSI Dynamic SQL

10.6.9 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. Variables 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, 10g Release 1 (10.1)

F E mbedded SQL Statements and Directives

F.35 EXECUTE IMMEDIATE (Executable Embedded SQL)EXECUTE IMMEDIATE statement, Oracle parses the specified SQL statement or PL/SQL block, checking for … 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

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

F Embedded SQL Statements and Precompiler Directives

F.25 EXECUTE IMMEDIATE (Executable Embedded SQL)When you issue an EXECUTE IMMEDIATE statement, Oracle9 i parses the specified SQL statement or PL/SQL … SQLCODE component of the SQLCA. For more information on this statement, see "The EXECUTE IMMEDIATE … Statement". Example This example illustrates the use of the EXECUTE IMMEDIATE statement: EXEC SQL … EXECUTE IMMEDIATE

Administrator's Guide, 10g Release 1 (10.1)

3 Starting Up and Shutting Down

Shutting Down with the IMMEDIATE ClauseUse 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 clause … : SHUTDOWN IMMEDIATE Immediate database shutdown proceeds with the following conditions: No new

Broker, 10g Release 1 (10.1)

4 R ole Management

4.2.4 How the Broker Performs an Immediate Failover Operation4.2.4 Ho w the Broker Performs an Immediate Failover Operation After determining that there is no … is shut down and then begin the failover operation. Once you start an immediate failover, the broker … new primary database in read/write mode, and starts log transport services. Because an immediate

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

11 Tuning PL/SQL Applications for Performance

Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables/SQL features involved are the EXECUTE IMMEDIATE statement and cursor variables (also known as REF

Broker, 10g Release 1 (10.1)

8 D atabase Properties

Corresponds to ... USING CURRENT LOGFILE clause of the ALTER DATABASE RECOVER MANAGED STANDBY DATABASE…DATABASE RECOVER MANAGED STANDBY DATABASE command for a physical standby database IMMEDIATE clause of

Error Messages, 10g Release 1 (10.1)

3 ORA-00910 to ORA-01497

ORA-01089: immediate shutdown in progress - no operations are permittedSHUTDOWN IMMEDIATE. ORA-01089: immediate shutdown in progress - no operations are permitted

Error Messages, 10g Release 1 (10.1)

28 NID-00001 to NID-00604

NID-00330: The following datafiles are offline immediate:Cause: Informational message. Action: No action required. NID-00330: The following datafiles are offline immediate:

Error Messages, 10g Release 1 (10.1)

28 NID-00001 to NID-00604

NID-00122: Database should have no offline immediate datafiles: Shutdown the database and mount it in exclusive mode. NID-00122: Database should have no offline immediate datafiles

Error Messages, 10g Release 1 (10.1)

15 ORA-24280 to ORA-28674

ORA-25201: invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE-25201: invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE

Error Messages, 10g Release 1 (10.1)

3 ORA-00910 to ORA-01497

ORA-01145: offline immediate disallowed unless media recovery enabledsize. ORA-01145: offline immediate disallowed unless media recovery enabled

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-16042: user requested cancel immediate of managed recovery operationregarding the error encountered and if possible take corrective action. ORA-16042: user requested cancel immediate of managed recovery operation

Broker, 10g Release 1 (10.1)

8 D atabase Properties

Corresponds to ... YES corresponds to the NODELAY clause of the ALTER DATABASE RECOVER MANAGED STANDBY…of the ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE statement


Was this page helpful?