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 DBMS_SQL


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


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

90 DBMS_SQL

Using DBMS_SQLOverview Security Model Constants Types Exceptions Operational Notes Examples

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

90 DBMS_SQL

90 DBMS_SQLThe DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation … DBMS_SQL package. See Also: For more information on native dynamic SQL, see PL/SQL User's Guide and … Reference. For a comparison of DBMS_SQL and native dynamic SQL, see Oracle Database Application … Developer's Guide - Fundamentals.

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

90 DBMS_SQL

Summary of DBMS_SQL SubprogramsTable 90-1   DBMS_SQL Package Subprograms Subprogram Description BIND_ARRAY Procedures Binds a … DBMS_SQL DESCRIBE_COLUMNS2 Procedure Describes describes the specified column, an alternative to

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

6 Coding Dynamic SQL Statements

Advantages of the DBMS_SQL PackageThe DBMS_SQL package provides the following advantages over native dynamic SQL: DBMS_SQL is … Supported in Client-Side Programs The DBMS_SQL package is supported in client-side programs, but native … dynamic SQL is not. Every call to the DBMS_SQL package from the client-side program translates to a PL … variable,

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

90 DBMS_SQL

TypesGeneral Types DESC_REC, DESC_TAB VARCHAR2A, DESC_REC2 VARCHAR2_TABLE Bulk SQL Types BFILE_TABLE BINARY_DOUBLE_TABLE BLOB_TABLE CLOB_TABLE DATE_TABLE INTERVAL_DAY_TO_SECOND_TABLE INTERVAL_YEAR_TO_MONTH_TABLE NUMBER_TABLE TIME_TABLE TIME_WITH_TIME_ZONE_TABLE TIMESTAMP_TABLE TIMESTAMP_WITH_LTZ_TABLE UROWID_TABLE VARCHAR2_TABLE

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

90 DBMS_SQL

BFILE_TABLETYPE bfile_table IS TABLE OF BFILE INDEX BY BINARY_INTEGER;

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

90 DBMS_SQL

COLUMN_VALUE ProcedureThis procedure returns the value of the cursor element for a given position in a given cursor. This procedure is used to access the data fetched by calling FETCH_ROWS.

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

90 DBMS_SQL

SyntaxDBMS_SQL.IS_OPEN ( c IN INTEGER) RETURN BOOLEAN;

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

90 DBMS_SQL

INTERVAL_YEAR_TO_MONTH_TABLETYPE interval_year_to_month_table IS TABLE OF yminterval_unconstrained INDEX BY BINARY_INTEGER;

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

90 DBMS_SQL

DESCRIBE_COLUMNS ProcedureThis procedure describes the columns for a cursor opened and parsed through DBMS_SQL.

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

90 DBMS_SQL

SyntaxDBMS_SQL.LAST_ERROR_POSITION RETURN INTEGER;

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

90 DBMS_SQL

PragmasPRAGMA RESTRICT_REFERENCES(describe_columns2,WNDS);

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

90 DBMS_SQL

DESC_REC, DESC_TABTYPE desc_rec IS RECORD ( col_type BINARY_INTEGER:= 0, col_max_len BINARY_INTEGER:= 0, col_name VARCHAR2(32):= '', col_name_len BINARY_INTEGER:= 0, col_schema_name VARCHAR2(32):= '', col_schema_name_len BINARY_INTEGER:= 0, col_precision BINARY_INTEGER:= 0, col_scale BINARY_INTEGER:= 0, col_charsetid BINARY_INTEGER:= 0, col_charsetform BINARY_INTEGER:= 0, col__ok BOOLEAN:= TRUE); TYPE desc_tab IS TABLE

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

90 DBMS_SQL

SyntaxDBMS_SQL.BIND_VARIABLE ( c IN INTEGER, name IN VARCHAR2, value IN ) Where can be any one of the following types: BINARY_DOUBLE BINARY_FLOAT BFILE BLOB CLOB CHARACTER SET ANY_CS DATE DSINTERVAL_UNCONSTRAINED NUMBER TIME_UNCONSTRAINED TIME_TZ_UNCONSTRAINED TIMESTAMP_LTZ_UNCONSTRAINED TIMESTAMP_TZ_UNCONSTRAINED TIMESTAMP_UNCONSTRAINED UROWID VARCHAR2 CHARACTER SET ANY_CS YMINTERVAL_UNCONSTRAINED Notice

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

90 DBMS_SQL

SyntaxDBMS_SQL.EXECUTE_AND_FETCH ( c IN INTEGER, exact IN BOOLEAN DEFAULT FALSE) RETURN INTEGER;

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

90 DBMS_SQL

Pragmaspragma restrict_references(last_row_id,RNDS,WNDS);

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

90 DBMS_SQL

SyntaxDBMS_SQL.DEFINE_COLUMN ( c IN INTEGER, position IN INTEGER, column IN ) Where can be any one of the following types: BINARY_DOUBLE BINARY_FLOAT BFILE BLOB CLOB CHARACTER SET ANY_CS DATE DSINTERVAL_UNCONSTRAINED NUMBER TIME_UNCONSTRAINED TIME_TZ_UNCONSTRAINED TIMESTAMP_LTZ_UNCONSTRAINED TIMESTAMP_TZ_UNCONSTRAINED TIMESTAMP_UNCONSTRAINED UROWID VARCHAR2 CHARACTER SET ANY_CS YMINTERVAL_UNCONSTRAINED

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

90 DBMS_SQL

Operational Notesprecompiler, OCI, or PL/SQL level, and are used only by the DBMS_SQL package. PARSE Every SQL statement … to the user side. Any such deadlock timeouts after five minutes. The execution flow of DBMS_SQL is … shown in Figure 90-1. Figure 90-1 DBMS_SQL Execution Flow Text description of the illustration … program has placed in the

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

90 DBMS_SQL

SyntaxDBMS_SQL.DEFINE_ARRAY ( c IN INTEGER, position IN INTEGER, IN cnt IN INTEGER, lower_bnd IN INTEGER); Where and its corresponding can be any one of the following matching pairs: Clob_Table Binary_Float_Table Binary_Double_Table Blob_Table Bfile_Table Date_Table Number_Table Urowid_Table Varchar2_Table Notice that DEFINE_ARRAY is overloaded to accept different datatypes.

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

90 DBMS_SQL

ParametersTable 90-8  DEFINE_COLUMN Procedure Parameters Parameter Description c ID number of the cursor for the row being defined to be selected. position Relative position of the column in the row being defined. The first column in a statement has position 1. column Value of the column being defined. The type of this value determines the type for the column being defined. column_size Maximum expected size