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 SQL


1 to 20 of 11741 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

Contents

ContentsDocumentation 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

SQL Quick Reference, 10g Release 1 (10.1)

Contents

ContentsDocumentation 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

SQL*Plus® User's Guide and Reference, 10g Release 1 (10.1)

Contents

ContentsAccessibility 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

Oracle® SQL*Module for Ada Programmer's Guide, 10g Release 1 (10.1)

Contents

ContentsConventions 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

Upgrade Guide, 10g Release 1 (10.1)

5 Compatibility and Interoperability

SQLStarting 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

DML Reference, 10g Release 1 (10.1)

SQL

SQLThe 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

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

4 Object Support in Oracle Programming Environments

SQLOracle 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.

Recovery Manager Reference, 10g Release 1 (10.1)

SQL

SQLSyntax sql::= Text description of sql

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting i SQL*Plusi 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

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting SQL*PlusSQL*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

DML Reference, 10g Release 1 (10.1)

SQL

statement-nameA 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

DML Reference, 10g Release 1 (10.1)

SQL

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

DML Reference, 10g Release 1 (10.1)

SQL

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

DML Reference, 10g Release 1 (10.1)

SQL

SQL OPENThe 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

DML Reference, 10g Release 1 (10.1)

SQL

SQL PREPAREThe 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

DML Reference, 10g Release 1 (10.1)

SQL

cursorThe 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

DML Reference, 10g Release 1 (10.1)

SQL

procedure-nameThe 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

Recovery Manager Reference, 10g Release 1 (10.1)

SQL

Examplesall 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

DML Reference, 10g Release 1 (10.1)

SQL

loopcountOptional 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

DML Reference, 10g Release 1 (10.1)

SQL

< 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