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

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

PL/SQL Static SQL

Statementsthe EXECUTE IMMEDIATE statement, explained in \"Native Dynamic SQL\". Note: After PL/SQL code runs … These are the PL/SQL static SQL statements, which have the same syntax as the corresponding SQL … statements, except as noted: SELECT (this statement is also called a query ) For the

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

PL/SQL Static SQL

Autonomous Triggersuse native dynamic SQL. See Also: Chapter 9, \"PL/SQL Triggers,\" for general information about … Language Reference for information about DDL statements \"Native Dynamic SQL\" for information about … native dynamic SQL One use of triggers is to log events transparently—for

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

Overview of PL/SQL

Tight Integration with SQLa Query Result Set One Row at a Time\" ). PL/SQL supports both static and dynamic SQL. Static SQL … is SQL whose full text is known at compilation time. Dynamic SQL is SQL whose full text is not known … until run time. Dynamic SQL

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

PL/SQL Subprograms

AUTHID and SQL Command SET ROLEROLE command from PL/SQL, you must use dynamic SQL, preferably the EXECUTE IMMEDIATE statement. For … The SQL command SET ROLE succeeds only if there are no DR units on the call stack. If at least one

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

Overview of PL/SQL

Support for Developing Web Applicationsflexibility of database processing. For example, you can use DML statements, dynamic SQL, and cursors … PL/SQL lets you create applications that generate web pages directly from the database, allowing … . The program flow of a PL/SQL Web application is similar to that in a CGI PERL script. Developers … accessing

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

Overview of PL/SQL

High Performanceimproves performance. PL/SQL does not create bind variables automatically when you use dynamic SQL, but … you can use them with dynamic SQL by specifying them explicitly (for details, see \"EXECUTE … PL/SQL lets you send a block of statements to the database, significantly reducing traffic

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

PL/SQL Subprograms

Invoker's Rights and Definer's Rights (AUTHID Property)currently enabled roles do not change. For dynamic SQL statements issued by a PL/SQL unit, name … The AUTHID property of a stored PL/SQL unit affects the name resolution and privilege checking of … SQL statements that the unit issues at run time. The AUTHID property does not affect compilation, and