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 DECLARE


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


Release 1.8, 10g Release 1 (10.1)

Using Dynamic SQL

DECLAREor program variable, but must be unique. It designates a particular dynamic SQL statement. DECLAREDECLARE defines a cursor by giving it a name and associating it with a specific query. The cursor … declaration is local to its precompilation unit. Continuing our example, DECLARE defines a cursor named emp_cursor and associates it with

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

13 Oracle Dynamic SQL

13.9.2 DECLAREDECLARE defines a cursor by giving it a name and associating it with a specific query. Continuing … our example, DECLARE defines a cursor named emp_cursor and associates it with sql_stmt, as follows … : EXEC SQL DECLARE emp_cursor CURSOR FOR sql_stmt; The identifiers sql_stmt and emp_cursor are not host … or program variables,

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

9 Oracle Dynamic SQL

9.11.2 DECLAREThe DECLARE statement defines a cursor by giving it a name and associating it with a specific query … . The cursor declaration is local to its precompilation unit. Continuing our example, DECLARE … defines a cursor named EMPCURSOR and associates it with SQLSTMT, as follows: EXEC SQL DECLARE EMPCURSOR … , but must be unique. If

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

2 Precompiler Concepts

2.3 The Declare SectionPassing data between the database server and your application program requires host variables and error handling. This section shows you how to meet these requirements.

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Writing a Pro*FORTRAN Program

The Declare SectionYou must declare all program variables to be used in SQL statements in the Declare Section, which … begins with the statement EXEC SQL BEGIN DECLARE SECTION and ends with the statement EXEC SQL END … DECLARE SECTION Between these two statements only the following are allowed:

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

11 Oracle Dynamic SQL: Method 4

11.6.2 Declare the SQLDAs-holders, you must declare select and bind descriptors. Instead of hard-coding the SQLDAs, you use

Pro*PL/1® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

1 Writing a Pro*PL/1 Program

1.2.1 The Declare SectionYou must declare all variables that will be used in embedded SQL statements inside a SQL Declare … Section, and the Declare Section must physically precede the embedded SQL statements that use the … block or a begin block. Each block that contains a SQL statement must have a Declare Section in scope … , even if

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

15 Oracle Dynamic SQL: Method 4

15.6.7 DECLARE a CursorDECLARE CURSOR defines a cursor by giving it a name and associating it with a specific SELECT … statement. To declare a cursor for static queries, you use the following syntax: EXEC SQL DECLARE … cursor_name CURSOR FOR SELECT... To declare a cursor for dynamic queries, the statement name given to the … dynamic

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

2 Precompiler Concepts

2.3.3 Declare SectionA Declare Section contains the host variable declarations and is of the form: EXEC SQL BEGIN … DECLARE SECTION; /* Declare all host variables inside this section: */ char *uid = "scott/tiger";... EXEC … SQL END DECLARE SECTION; A Declare Section begins with the statement: EXEC SQL BEGIN DECLARE

Pro*PL/1® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

5 Implementing Dynamic SQL Method 4

5.4.3 Declare the SQLDAsUse INCLUDE to copy the files containing the SQLDA declarations into your program, as follows: EXEC SQL INCLUDE SELDSC; /* select descriptor */ EXEC SQL INCLUDE BNDDSC; /* bind descriptor */

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Implementing Dynamic SQL Method 4

DECLARE a CursorEXEC SQL PREPARE DYNSTMT FROM:SELSTM DECLARE a Cursor DECLARE CURSOR defines a cursor by giving it … a name and associating it with a specific SELECT statement. To declare a cursor for static queries, you use the following syntax:

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

15 Oracle Dynamic SQL: Method 4

15.6.2 Declare the SQLDAs-list items or placeholders for bind variables, you declare pointers to select and bind descriptors, as follows: sqlda *select_des; sqlda *bind_des;

Pro*PL/1® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

5 Implementing Dynamic SQL Method 4

5.4.8 DECLARE a CursorDECLARE CURSOR defines a cursor by giving it a name and associating it with a specific query. When … declaring a cursor for static queries, you use the following syntax: EXEC SQL DECLARE CURSOR_NAME … dynamic query by PREPARE is substituted for the static query. In our example, DECLARE CURSOR defines a … cursor named EMP_CURSOR

DML Reference, 10g Release 1 (10.1)

SQL

SQL DECLARE CURSORThe SQL DECLARE CURSOR command defines an explicit SQL cursor by associating it with a SELECT … about tables and columns. Syntax SQL DECLARE  cursor  CURSOR FOR { select-statement [FOR UPDATE

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

11 Oracle Dynamic SQL: Method 4

11.6.7 DECLARE a CursorDECLARE CURSOR defines a cursor by giving it a name and associating it with a specific SELECT … statement. To declare a cursor for static queries, use the following syntax: EXEC SQL DECLARE cursor_name … CURSOR FOR SELECT... To declare a cursor for dynamic queries, the statement name given to the … dynamic query

Release 1.8, 10g Release 1 (10.1)

Meeting Program Requirements

The Declare SectionYou must declare all program variables to be used in SQL statements (that is, all host variables … ) in the Declare Section. If you use an undeclared host variable in a SQL statement, the precompiler

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

11 Oracle Dynamic SQL: Method 4

11.6.1 Declare a Host Stringvariable (SELECTSTMT in our example) must be declared as a character string: EXEC SQL BEGIN DECLARE SECTION … END-EXEC.... 01 SELECTSTMT PIC X(120). EXEC SQL END DECLARE SECTION END-EXEC.

Release 1.8, 10g Release 1 (10.1)

Embedded SQL Commands and Directives

DECLARE STATEMENT (Embedded SQL Directive)Purpose To declare an identifier for a SQL statement or PL/SQL block to be used in other embedded SQL statements.

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

6 Embedded SQL

6.5.1 The DECLARE CURSOR StatementYou use the DECLARE CURSOR statement to define a cursor by giving it a name and associating it with … a query, as the following example shows: EXEC SQL DECLARE emp_cursor CURSOR FOR SELECT ename, empno … , not a host or program variable, and should not be defined in the Declare Section. Cursor names … are part of the FETCH statement.

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

15 Oracle Dynamic SQL: Method 4

15.6.1 Declare a Host StringYour program needs a host variable to store the text of the dynamic SQL statement. The host variable ( select_stmt in our example) must be declared as a character string.... int emp_number; VARCHAR emp_name[10]; VARCHAR select_stmt[120]; float bonus;