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 dynamic SQL


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


Database PL/SQL Language Reference, 11g Release 1 (11.1)

Database PL/SQL Language Reference - Contents

ContentsHow PL/SQL Loops Repeat Dynamic Ranges for Loop Bounds Scope of the Loop Counter Variable Using the … Autonomous Triggers Invoking Autonomous Functions from SQL 7 Using Dynamic SQL When You Need DynamicSQL Using Native Dynamic SQL

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

7 Using Dynamic SQLDynamic SQL is a programming methodology for generating and executing SQL statements at run time … provides two ways to write dynamic SQL: Native dynamic SQL, a PL/SQL language (that is, native) feature for … building and executing dynamic

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Using Native Dynamic SQLNative dynamic SQL processes most dynamic SQL statements by means of the EXECUTE IMMEDIATE … statement. If the dynamic SQL statement is a SELECT statement that returns multiple rows, native dynamic SQL … after native dynamic SQL

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

When You Need Dynamic SQLIn PL/SQL, you need dynamic SQL in order to execute the following: SQL whose text is unknown at … of Static SQL. If you do not need dynamic SQL, use static SQL, which has the following advantages … time. SQL that is not supported as

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Using the OPEN-FOR, FETCH, and CLOSE StatementsIf the dynamic SQL statement represents a SELECT statement that returns multiple rows, you can … process it with native dynamic SQL as follows: Use an OPEN-FOR statement to associate a cursor variable … with the dynamic SQL statement. In the USING clause of the OPEN-FOR statement, specify

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

DBMS_SQL.TO_REFCURSOR FunctionPL/SQL data type REF CURSOR, which you can use in native dynamic SQL statements. Before passing a … native dynamic SQL. Example 7-6 Switching from DBMS_SQL Package to Native Dynamic SQL CREATE OR REPLACE … from DBMS_SQL to native dynamic SQL:

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Avoiding SQL Injection in PL/SQLSQL injection is a technique for maliciously exploiting applications that use client-supplied data … in SQL statements, thereby gaining unauthorized access to a database in order to view or manipulate … restricted data. This section describes SQL injection vulnerabilities in PL/SQL and explains how to … statements

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Using the EXECUTE IMMEDIATE StatementThe EXECUTE IMMEDIATE statement is the means by which native dynamic SQL processes most dynamic SQL … statements. If the dynamic SQL statement is self-contained (that is, if it has no placeholders for … IMMEDIATE statement needs no clauses. If the dynamic SQL

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Guarding Against SQL InjectionIf you use dynamic SQL in your PL/SQL applications, you must check the input text to ensure that it … SQL injection because it builds the dynamic SQL statement with bind arguments (not by concatenation … the anonymous PL/SQL block invokes the procedure from both a dynamic

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Repeating Placeholder Names in Dynamic SQL StatementsIf you repeat placeholder names in dynamic SQL statements, be aware that the way placeholders are … associated with bind arguments depends on the kind of dynamic SQL statement. Topics: Dynamic SQL … Statement is Not Anonymous Block or CALL Statement Dynamic SQL

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Using DBMS_SQL PackageDBMS_SQL package to execute a dynamic SQL statement when you don't know either of the following until … situations, you must use native dynamic SQL instead of the DBMS_SQL package: The dynamic SQL … , or %ROWCOUNT after issuing a dynamic SQL statement

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

DBMS_SQL.TO_CURSOR_NUMBER Functionto a SQL cursor number, native dynamic SQL operations cannot access it. After a FETCH operation … causes an error. Example 7-7 uses the DBMS_SQL. TO_CURSOR function to switch from native dynamic SQL … to the DBMS_SQL package. Example 7-7 Switching from Native Dynamic SQL

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Dynamic SQL

Overview of SQL Injection Techniquescorrectly validated and is concatenated into a dynamic SQL statement. This topic classifies SQL … Modification Statement modification means deliberately altering a dynamic SQL statement so that it … means that a user appends one or more new SQL statements to a dynamic

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Tuning PL/SQL Applications for Performance

Tuning Dynamic SQL with EXECUTE IMMEDIATE Statement and Cursor Variablesprobably change from execution to execution. They are called dynamic SQL statements. Formerly, to execute … dynamic SQL statements, you had to use the supplied package DBMS_SQL. Now, within PL/SQL, you can … execute any kind of dynamic SQL statement using an interface

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

Oracle Dynamic SQL

Dynamic SQLdynamic SQL statements. Unlike static SQL statements, dynamic SQL statements are not embedded in your … each column. However, some applications must accept (or build) and process a variety of SQL statements

SQL*Module for Ada Programmer's Guide, 11g Release 1 (11.1)

Accessing Stored Procedures

Dynamic SQLis the capability of executing SQL commands that are stored in character string variables. The

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

ANSI Dynamic SQL

14 ANSI Dynamic SQLThis chapter describes Oracle's implementation of ANSI dynamic SQL (also known as SQL92 dynamic SQLdynamic SQL Method 4, described in the previous chapter. The ANSI Method 4 supports all Oracle types … , DML returning clauses, Unicode variables, and LOBs. In ANSI dynamic

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

ANSI Dynamic SQL

10 ANSI Dynamic SQLThis chapter describes Oracle's implementation of ANSI dynamic SQL (also known as SQL92 dynamic SQLdynamic SQL Method 4, which is described in Chapter 11, \"Oracle Dynamic SQL: Method 4\". The ANSI … , tables of group items, the DML returning clause,

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

Oracle Dynamic SQL

13 Oracle Dynamic SQLThis chapter shows you how to use Oracle Dynamic SQL, an advanced programming technique that adds … : Oracle Dynamic SQL does not support object types, cursor variables, arrays of structs, DML … returning clauses, Unicode variables, and LOBs. Use ANSI Dynamic SQL method 4 instead. What

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

Oracle Dynamic SQL

9 Oracle Dynamic SQLThis chapter shows you how to use dynamic SQL, an advanced programming technique that adds … dynamic SQL, you learn four methods—from simple to complex—for writing programs that accept and process … and how to choose the right method for a given job. Topics are: Dynamic SQL Advantages