How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Contents → Autonomous Triggers Invoking Autonomous Functions from SQL 7 PL/SQL Dynamic SQL When You Need Dynamic … SQL Native Dynamic SQL EXECUTE IMMEDIATE Statement OPEN FOR, FETCH, and CLOSE Statements Repeated … Placeholder Names in Dynamic
7 PL/SQL Dynamic SQL → Dynamic 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
Native Dynamic SQL → Native 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,
SQL Injection → SQL 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
Repeated Placeholder Names in Dynamic SQL Statements → If 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
DBMS_SQL.TO_CURSOR_NUMBER Function → variable 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
DBMS_SQL.TO_REFCURSOR Function → you 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
EXECUTE IMMEDIATE Statement → The 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
When You Need Dynamic SQL → In 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
Guarding Against SQL Injection → If 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
DBMS_SQL Package → package 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,
OPEN FOR, FETCH, and CLOSE Statements → If 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
SQL Injection Techniques → validated 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
Statements → the 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
Autonomous Triggers → use 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
Tight Integration with SQL → a 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
AUTHID and SQL Command SET ROLE → ROLE 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
Support for Developing Web Applications → flexibility 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
High Performance → improves 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
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