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 24800 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference, 11g Release 2 (11.2)

Database PL/SQL Language Reference - Contents

ContentsAutonomous Triggers Invoking Autonomous Functions from SQL 7 PL/SQL Dynamic SQL When You Need DynamicSQL Native Dynamic SQL EXECUTE IMMEDIATE Statement OPEN FOR, FETCH, and CLOSE Statements Repeated … Placeholder Names in Dynamic

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

Native Dynamic SQLNative dynamic SQL processes most dynamic SQL statements with the EXECUTE IMMEDIATE statement. If … the dynamic SQL statement is a SELECT statement that returns multiple rows, native dynamic SQL gives … dynamic SQL INSERT,

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

SQL InjectionSQL injection maliciously exploits applications that use client-supplied data in SQL statements … describes SQL injection vulnerabilities in PL/SQL and explains how to guard against them. To try the … Setup for SQL Injection Examples DROP TABLE secret_records; CREATE TABLE secret_records ( user_name

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

Repeated Placeholder Names in Dynamic SQL StatementsIf you repeat placeholder names in dynamic SQL statements, be aware that the way placeholders are … associated with bind variables 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 2 (11.2)

PL/SQL Dynamic SQL

DBMS_SQL.TO_CURSOR_NUMBER Functionvariable to a SQL cursor number, native dynamic SQL operations cannot access it. Example 7-7 uses the … DBMS_SQL. TO_CURSOR_NUMBER function to switch from native dynamic SQL to the DBMS_SQL package. Example 7 … -7 Switching from Native Dynamic SQL to DBMS_SQL Package

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

DBMS_SQL.TO_REFCURSOR Functionyou can use in native dynamic SQL statements. Before passing a SQL cursor number to the DBMS_SQL … . TO_REFCURSOR function to switch from the DBMS_SQL package to native dynamic SQL. Example 7-6 … Switching from DBMS_SQL Package to Native Dynamic SQL CREATE OR REPLACE

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

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 2 (11.2)

PL/SQL Dynamic SQL

When You Need Dynamic SQLIn PL/SQL, you need dynamic SQL to run: SQL whose text is unknown at compile time For example, a … do not need dynamic SQL, use static SQL, which has these advantages: Successful compilation verifies … a WHERE clause in which the number of subclauses is unknown at compile

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL 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 … performance.) The procedure in Example 7-12 is invulnerable to SQL injection because it builds the dynamic SQL … both a dynamic PL/SQL block and a dynamic

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

DBMS_SQL Packagepackage to run a dynamic SQL statement when you do not know either of these until run time: SELECT … native dynamic SQL instead of the DBMS_SQL package: The dynamic SQL statement retrieves rows into … a dynamic SQL statement that is an INSERT, UPDATE,

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Dynamic SQL

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 2 (11.2)

PL/SQL Dynamic SQL

SQL Injection Techniquesvalidated and is concatenated into a dynamic SQL statement. Topics Statement Modification Statement … dynamic SQL statement so that it runs in a way unintended by the application developer. Typically … to a dynamic SQL statement. Anonymous PL/SQL blocks are vulnerable

SQL*Module for Ada Programmer's Guide, 11g Release 2 (11.2)

Accessing Stored Procedures

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

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

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

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Oracle Dynamic SQL

What is Dynamic SQL?dynamic 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

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

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*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Oracle Dynamic SQL

Dynamic SQL Statement Cachingperformance improvement of all applications that rely on the dynamic SQL statements. Performance … number of distinct dynamic SQL statements in the application. Example 13-1 Using the stmt_cache Option … (dynstmt.arr); EXEC SQL PREPARE S FROM:dynstmt; printf (\"Inserts %d rows into bonus table using

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

Oracle Dynamic SQL

Dynamic SQL Statement Cachingperformance improvement of all applications that rely on the dynamic SQL statements. The … can be set to hold the anticipated number of distinct dynamic SQL statements in the application … performance improvement is achieved by removing the overhead of parsing the dynamic statements on reuse. The

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

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