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 → How 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 Dynamic … SQL Using Native Dynamic SQL
7 Using Dynamic SQL → Dynamic 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
Using Native Dynamic SQL → Native 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
When You Need Dynamic SQL → In 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
Using the 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
DBMS_SQL.TO_REFCURSOR Function → PL/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:
Avoiding SQL Injection in PL/SQL → SQL 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
Using the 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
Guarding Against SQL Injection → If 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
Repeating 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 arguments depends on the kind of dynamic SQL statement. Topics: Dynamic SQL … Statement is Not Anonymous Block or CALL Statement Dynamic SQL
Using DBMS_SQL Package → DBMS_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
DBMS_SQL.TO_CURSOR_NUMBER Function → to 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
Overview of SQL Injection Techniques → correctly 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
Tuning Dynamic SQL with EXECUTE IMMEDIATE Statement and Cursor Variables → probably 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
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
Dynamic SQL → is the capability of executing SQL commands that are stored in character string variables. The
14 ANSI Dynamic SQL → This chapter describes Oracle's implementation of ANSI dynamic SQL (also known as SQL92 dynamic SQL … dynamic 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
10 ANSI Dynamic SQL → This chapter describes Oracle's implementation of ANSI dynamic SQL (also known as SQL92 dynamic SQL … dynamic SQL Method 4, which is described in Chapter 11, \"Oracle Dynamic SQL: Method 4\". The ANSI … , tables of group items, the DML returning clause,
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
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