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 → Documentation Conventions Documentation Accessibility What's New in the SQL Reference? Oracle Database 10 g … New Features in the SQL Reference 1 Introduction to Oracle SQL History of SQL SQL Standards How SQL … Works Common Language for All Relational Databases Recent Enhancements Nonstandard
Contents → Documentation Conventions Documentation Accessibility 1 SQL Statements Syntax for SQL Statements 2 SQL … Functions Syntax for SQL Functions 3 SQL Expressions Syntax for SQL Expression Types 4 SQL Conditions … Syntax for SQL Condition Types 5 Subclauses
Contents → Accessibility Structure Related Documents Conventions What's New in SQL*Plus? New Features in SQL*Plus … and i SQL*Plus 10.1 SQL*Plus Quick Start Resources What is SQL*Plus Before Starting SQL*Plus or i SQL … *Plus Starting SQL*Plus Command-line Starting
Contents → Conventions 1 Introduction to SQL*Module 1.1 What Is SQL*Module? 1.1.1 Background 1.1.2 Precompilers 1.1.3 The … Module Language Concept 1.2 SQL*Module as an Interface Builder 1.3 What Is Supported by SQL*Module … ? 1.4 What SQL Statements are Not Supported by SQL*Module? 2 Module Language
SQL → Starting with Oracle Database 10 g release 10.1, CLOB NCLOB implicit conversion in SQL and PL/SQL … of a synonym does not exist, the SQL compiler now tries looking up PUBLIC.base_object. Starting
SQL → The SQL command passes instructions written in Structured Query Language (SQL) to the relational … manager from Oracle OLAP. Using the SQL command, you can insert and update data in relational tables
SQL → Oracle SQL DDL provides the following support for object types: Defining object types, nested … tables Oracle SQL DML provides the following support for object types: Querying and updating objects … and collections Manipulating REF s See Also: For a complete description of Oracle SQL syntax, see Oracle Database SQL Reference.
Starting i SQL*Plus → i SQL*Plus is the Web version of SQL*Plus. Before you can connect to it with a URL, you must start … the i SQL*Plus application server. To do so, enter the following at the command line: isqlplusctl … start After the server is started, you can connect to i SQL*Plus with a URL such as http … ://machine_name:5560/isqlplus
Starting SQL*Plus → SQL*Plus is a command line program you use to issue SQL statements to an Oracle database. You can … issue these statements interactively or in batch. SQL*Plus comes with your Oracle installation and is … located in your $ORACLE_HOME/bin directory. To start SQL*Plus, enter the following at the command … you set
statement-name → A name that you assign to the executable code produced from sql-statement. You can redefine … statement-name just by issuing another SQL PREPARE command. sql-statement The SQL statement that you want … sql-statement is an INSERT statement: DIRECT=YES|NO specifies if the insert is a direct-path INSERT
SQL CLOSE → The SQL CLOSE command closes a SQL cursor. After you have closed a cursor, you cannot use it again … unless you issue a new SQL OPEN command. Syntax SQL CLOSE cursor Arguments
cursor → , SQL FETCH will continue processing rows until it reaches the end of the active set specified by the … to improve the performance of SQL FETCH. When you do not specify a LOOP clause and the cursor … contains more than one row in its active set, you must code the SQL FETCH command within a WHILE loop
SQL OPEN → The SQL OPEN command activates an explicitly-declared SQL cursor. When the cursor is opened, SQL … cursor's result set, and leaves the cursor in the open state for use by SQL FETCH or SQL IMPORT. The … cursor is positioned before the first row of the result set. Syntax SQL OPEN cursor
SQL PREPARE → The SQL PREPARE command precompiles a SQL statement for later execution using SQL EXECUTE … . Typically, you use SQL PREPARE in programs to optimize the processing of SQL statements that will be … . Syntax SQL PREPARE statement-name FROM sql-statement [ insert-options
cursor → The name of a cursor previously opened with a SQL OPEN command. Notes Related OLAP DML Commands You … use the SQL OPEN command in combination with other SQL commands to copy data from relational tables … the cursor, setting the value of an input host variable, and issuing a new SQL OPEN command. You do not have to free
procedure-name → The name of the SQL stored procedure. sql-parameter The name of a variable in the RDBMS.: dml … DML variables. See "SQL Terminology" and "Input Host Variables" for more information on host … variables. Notes Creating SQL Procedures using the OLAP DML To create a stored procedure using the OLAP … DML, issue an
Examples → all unarchived online logs: BACKUP TABLESPACE users; SQL "ALTER SYSTEM ARCHIVE LOG CURRENT … single quotes within the context of a double-quoted string: SQL "ALTER TABLESPACE tbs_1 ADD DATAFILE … ''/oracle/dbs/tbs_7.f'' NEXT 10K MAXSIZE 100k;" Executing a PL/SQL Stored Procedure Within RMAN … : Example This example issues a PL/SQL
loopcount → Optional integer argument to the LOOP keyword. Loopcount controls how SQL FETCH will loop over the … clause without a value for loopcount, SQL FETCH will continue reading rows and copying their … , each row is processed until SQLCODE is nonzero. When you specify a literal value for loopcount, SQL … specifies the number of rows
< action-statement-group > → for every value in status of the ACROSS dimension. Notes Related OLAP DML Commands You use the SQL … IMPORT command in combination with other SQL commands to copy data from relational tables into analytic … objects according to this temporary status. Differences Between SQL FETCH and SQL IMPORT SQL FETCH