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
Dynamic SQL → is the capability of executing SQL commands that are stored in character string variables. The
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
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
13 Oracle Dynamic SQL → This 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
Dynamic SQL Statement Caching → performance 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
Dynamic SQL Statement Caching → performance 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
9 Oracle Dynamic SQL → This 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