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 INTO


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


PL/SQL Language Reference, Release 12.2

RETURNING INTO Clause

The EXECUTE IMMEDIATE statement builds and runs a dynamic SQL statement in a single operation.The RETURNING INTO clause specifies the variables in which to store the values returned by the … RETURNING INTO clause belongs to a DELETE, INSERT, or UPDATE statement. The dynamic RETURNING INTO clause … belongs to the EXECUTE IMMEDIATE statement. Note: You cannot use the RETURNING INTO clause for remote … COLLECT

PL/SQL Language Reference, Release 12.2

SELECT INTO Statement

The assignment statement sets the value of a data item to a valid value.The SELECT INTO statement retrieves values from one or more database tables (as the SQL SELECT … SELECT INTO statement with the BULK COLLECT clause is vulnerable to aliasing, which can cause … unexpected results. For details, see \" SELECT BULK COLLECT INTO Statements and Aliasing \". See Also … SQL SELECT statement (not a PL/SQL

SQL Language Reference, Release 18c

Automatic Locks in DML Operations

MERGE INTO table ... Yes SX Y Y N N NN N N MERGE INTO table... Yes SX Y Y N N N DELETE FROM table... Yes SX Y Footref 1 Y Footref 1 N

Database PL/SQL Language Reference, Release 18c

SELECT INTO Statement

The assignment statement sets the value of a data item to a valid value.The SELECT INTO statement retrieves values from one or more database tables (as the SQL SELECT … SELECT INTO statement with the BULK COLLECT clause is vulnerable to aliasing, which can cause … unexpected results. For details, see \" SELECT BULK COLLECT INTO Statements and Aliasing \". See Also … of duplicates. select_list If the

Database PL/SQL Language Reference, Release 18c

RETURNING INTO Clause

The EXECUTE IMMEDIATE statement builds and runs a dynamic SQL statement in a single operation.The RETURNING INTO clause specifies the variables in which to store the values returned by the … RETURNING INTO clause belongs to a DELETE, INSERT, or UPDATE statement. The dynamic RETURNING INTO clause … belongs to the EXECUTE IMMEDIATE statement. Note: You cannot use the RETURNING INTO clause for remote … RETURN

Spatial and Graph Developer's Guide, Release 18c

Loading ESRI Shapefiles into Spatial and Graph

D.1 Usage of the Shapefile ConverterThe Java shapefile converter transforms an ESRI shapefile into an Oracle Database table for use … shapefile directly into a database table, with the Oracle-equivalent.dbf data types for the attribute … columns and the SDO_GEOMETRY data type for the geometry column. To load a shapefile into the database … conversions and at the

Multitenant Administrator's Guide, Release 18c

Logging into a CDB or a PDB

In a multitenant environment, you can log in to a CDB or a PDB, and switch from a PDB to a different…the feature that you requested while logging in. To log into a multitenant environment as a CDB … -scoped feature: Log into Oracle Enterprise Manager Cloud Control as either user SYSTEM or SYSMAN. The … . Remember that only common users can log into the root, and that the names of common users begin with C … ## or c##. Both common

Spatial and Graph Developer's Guide, Release 18c

Loading ESRI Shapefiles into Spatial and Graph

D.2 Examples of the Shapefile ConverterParent topic: Loading ESRI Shapefiles into Spatial and Graph

SQL Tuning Guide, Release 18c

Optimizer Statistics Concepts

10.3.3.2 Global Statistics During Inserts into Empty Partitioned TablesWhen inserting rows into an empty partitioned table, the database gathers global statistics during … the insert. For example, if sales is an empty partitioned table, and if you run INSERT INTO sales … into a particular partition or subpartition, which is empty. The database gathers statistics on the … that you run INSERT INTO

Multitenant Administrator's Guide, Release 18c

Logging into a Multitenant Environment in Enterprise Manager

Logging into a Multitenant Environment in Enterprise Managerdifferent PDB or to the root. This section contains the following topics: Logging into a CDB or a PDB

Database PL/SQL Language Reference, Release 18c

PL/SQL Collections and Records

5.15 Inserting Records into TablesThe PL/SQL extension to the SQL INSERT statement lets you insert a record into a table. The record … restrictions on inserting records into tables, see \" Restrictions on Record Inserts and Updates … \". To efficiently insert a collection of records into a table, put the INSERT statement inside a FORALL … initializes it by putting

Automatic Storage Management Administrator's Guide, Release 18c

Initialization Parameters for Oracle ASM Instances

Creating, Copying, and Moving an SPFILE Into a Disk Groupcreate, copy, or move an Oracle ASM SPFILE into the disk group. For example, after upgrading an instance

PL/SQL Language Reference, Release 12.2

PL/SQL Optimization and Tuning

The SELECT INTO statement with the BULK COLLECT clause also called the SELECT BULK COLLECT INTO statement…uses the VALUES OF clause to reference a collection of pointers into another collection, you must … department_id BULK COLLECT INTO deptnums FROM departments; FORALL i IN 1..deptnums.COUNT INSERT INTO … in: SELECT INTO statement FETCH statement RETURNING INTO clause of: DELETE statement INSERT

PL/SQL Language Reference, Release 12.2

PL/SQL Triggers

INSERT INTO event_table VALUES ('top stack error message' || ora_server_error_msg(1) );INSERT INTO event_table VALUES ('top stack error message' || ora_server_error_msg(1 … )); ora_server_error_num_params ( position IN PLS_INTEGER ) PLS_INTEGER: Number of strings substituted into error

SQL Language Reference, Release 12.2

Automatic Locks in DML Operations

MERGE INTO table ... Yes SX Y Y N N NN N N MERGE INTO table... Yes SX Y Y N N N DELETE FROM table... Yes SX Y Footref 1 Y Footref 1 N

Database PL/SQL Language Reference, Release 18c

PL/SQL Optimization and Tuning

12.4.2.1 SELECT INTO Statement with BULK COLLECT ClauseThe SELECT INTO statement with the BULK COLLECT clause (also called the SELECT BULK COLLECT INTO … statement) selects an entire result set into one or more collection variables. For more information … , see \" SELECT INTO Statement \". Caution: The SELECT BULK COLLECT INTO statement is vulnerable to

Database PL/SQL Language Reference, Release 18c

PL/SQL Language Fundamentals

2.6.2 Assigning Values to Variables with the SELECT INTO StatementA simple form of the SELECT INTO statement is: SELECT select_item [, select_item ]... INTO … BOOLEAN variable. For the complete syntax of the SELECT INTO statement, see \" SELECT INTO Statement … \". Example 2-25 Assigning Value to Variable with SELECT INTO Statement This example uses a SELECT

Database PL/SQL Language Reference, Release 18c

PL/SQL Triggers

INSERT INTO event_table VALUES ('top stack error message' || ora_server_error_msg(1) );INSERT INTO event_table VALUES ('top stack error message' || ora_server_error_msg(1 … )); ora_server_error_num_params ( position IN PLS_INTEGER ) PLS_INTEGER: Number of strings substituted into error

Database PL/SQL Language Reference, Release 18c

PL/SQL Optimization and Tuning

12.4.2.3 RETURNING INTO Clause with BULK COLLECT Clausestatement fetches ten rows (or fewer) into associative array empids (overwriting the previous values … rows or fewer in each iteration FETCH c1 BULK COLLECT INTO empids LIMIT 10; DBMS_OUTPUT.PUT_LINE … : 175 Employee Id: 176 Employee Id: 177 Employee Id: 179 12.4.2.3 RETURNING INTO Clause with BULK … COLLECT Clause The RETURNING

Database PL/SQL Language Reference, Release 18c

PL/SQL Static SQL

6.3.1 Processing Query Result Sets With SELECT INTO StatementsUsing an implicit cursor, the SELECT INTO statement retrieves values from one or more database … : \" SELECT INTO Statement \" for its complete syntax and semantics