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 1733 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

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*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL

DECLAREexample, 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, but must be unique. If you declare two cursors using the same statement name, the … emp_cursor and associate

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

Precompiler Concepts

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/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

Declare the Data BuffersYou must declare data buffers to hold the bind variables and the returned select-list items. In our

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

Oracle Dynamic SQL: Method 4

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

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

Declare a Host Stringour example) must be declared as a character string. EXEC SQL BEGIN DECLARE SECTION;... DCL SELECT_STMT CHARACTER (120); EXEC SQL END DECLARE SECTION;

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

Precompiler Concepts

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*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL: Method 4

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

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Writing a Pro*PL/I Program

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*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

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*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

New Features

Optional Declare SectionUse of the BEGIN DECLARE SECTION and END DECLARE SECTION statements is now optional when … DECLARE_SECTION=NO (the default). If used, the DECLARE statements must be properly paired within the same

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

Oracle Dynamic SQL: Method 4

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, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL: Method 4

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/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

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

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

Oracle Dynamic SQL: Method 4

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.

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

Datatypes and Host Variables

Declare a Cursor VariableYou declare a cursor variable in your Pro*C/C++ program using the Pro*C/C++ pseudotype SQL_CURSOR … . For example: EXEC SQL BEGIN DECLARE SECTION; sql_cursor emp_cursor; /* a cursor variable … */... EXEC SQL END DECLARE SECTION; ecp = &emp_cursor; /* assign a value to the pointer */ You can … declare a cursor

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

Oracle Dynamic SQL: Method 4

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;

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

Embedded SQL

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.

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

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, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL

Using the DECLARE STATEMENT StatementWith Methods 2, 3, and 4, you might need to use the statement EXEC SQL [AT db_name] DECLARE … host or program variables. DECLARE STATEMENT declares the name of a dynamic SQL statement so that the … statement can be referenced by PREPARE, EXECUTE, DECLARE CURSOR, and DESCRIBE. It is required if you … follows: EXEC SQL AT remote_db