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 INSERT


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


SQL Reference, 10g Release 1 (10.1)

INSERT

Restrictions on Multitable Insertsperform a multitable insert into a remote table. You cannot specify a table collection expression … when performing a multitable insert. In a multitable insert, all of the insert_into_clause s cannot … a bitmap index defined on it. Plan stability is not supported for multitable insert statements. The … subquery

SQL Reference, 10g Release 1 (10.1)

INSERT

INSERTPurpose Use the INSERT statement to add rows to a table, the base table of a view, a partition of a … For you to insert rows into a table, the table must be in your own schema or you must have the INSERT … object privilege on the table. For you to insert rows into the base table of a view, the owner of … the schema

SQL Reference, 10g Release 1 (10.1)

INSERT

Restrictions on Inserted Values… That is, you cannot use a literal. You cannot insert a BFILE value until you have initialized the … initializing BFILE locators When inserting into a list-partitioned table, you cannot insert a value into … partitions. You cannot specify DEFAULT when inserting into a view. If you insert string literals into a … multitable

User's Guide and Reference, 10g Release 1 (10.1)

INSERT Statement

INSERT StatementThe INSERT statement adds one or more new rows of data to a database table. For a full description … of the INSERT statement, see Oracle Database SQL Reference. Syntax Description of the illustration … INSERT statement, and for which you must have INSERT privileges. For the syntax of table_reference, see … , %ROWCOUNT,

Release 1.8, 10g Release 1 (10.1)

Embedded SQL Commands and Directives

INSERT (Executable Embedded SQL)Purpose To add rows to a table or to a view's base table.

Administrator's Guide, 10g Release 1 (10.1)

14 Managing Tables

Enabling Direct-Path INSERTYou can implement direct-path INSERT operations by using direct-path INSERT statements, inserting … inserts can be done in either serial or parallel mode. To activate direct-path INSERT in serial mode … , you must specify the APPEND hint in each INSERT statement, either immediately after the INSERT

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

6 Embedded SQL

6.2.1 Insert NULLsYou can use indicator variables to INSERT NULLs. Before the INSERT, for each column you want to be … = -1; EXEC SQL INSERT INTO emp (empno, comm) VALUES (:emp_number,:commission:ind_comm); The … NULL instead, as follows: EXEC SQL INSERT INTO emp (empno, comm) VALUES (:emp_number, NULL); While … this is less flexible,

Utilities, 10g Release 1 (10.1)

11 Conventional and Direct Path Loads

Database Insert TriggersTable insert triggers are also disabled when a direct path load begins. After the rows are loaded … . Unlike integrity constraints, insert triggers are not reapplied to the whole table when they are … enabled. As a result, insert triggers do not fire for any rows loaded on the direct path. When using the … direct path, the application

Developer's Guide, 10g Release 1 (10.1)

11 DBMS_XMLSTORE

Insert Processing with DBMS_XMLSTORETo insert an XML document into a table or view, simply supply the table or the view name and then … the document. DBMS_XMLSTORE parses the document and then creates an INSERT statement into which it … '); DBMS_XMLStore.setUpdateColumn(insCtx,'SAL'); DBMS_XMLStore.setUpdatecolumn(insCtx,'HIREDATE'); -- Now insert the doc … . --

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

6 Embedded SQL

6.3.2 The INSERT StatementUse the INSERT statement to add rows to a table or view. In the following example, you add a row to … the EMP table: EXEC SQL INSERT INTO emp (empno, ename, sal, deptno) VALUES (:emp_number,:emp_name … each column in the table, in the order that they are defined in the table. See Also: "INSERT … inserted by a CREATE TABLE or INSERT

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Creating a BEFORE INSERT TriggerIn this case study, a BEFORE INSERT trigger is required to fill in the department number, job name … . The INSERT trigger and the global variables package are created when you execute the ulcase7s. sql … uldemo7; / The definition of the INSERT trigger looks as follows: CREATE OR REPLACE TRIGGER … uldemo7_emp_insert BEFORE INSERT

Administrator's Guide, 10g Release 1 (10.1)

14 Managing Tables

How Direct-Path INSERT WorksYou can use direct-path INSERT on both partitioned and nonpartitioned tables. Serial Direct-Path … INSERT into Partitioned or Nonpartitioned Tables The single process inserts data beyond the current … is updated to the new value, making the data visible to users. Parallel Direct-Path INSERT into … Partitioned Tables This situation

Reference, 10g Release 1 (10.1)

C Text Loading Examples for Oracle Text

C.1 SQL INSERT ExampleCREATE TABLE and then use the INSERT statement to load the data. This example makes the id column the … key, text varchar2(80)); To populate the text column, use the INSERT statement as follows: insert into … docs values(1, 'this is the text of the first document'); insert into docs values(12, 'this is the text of the

Administrator's Guide, 10g Release 1 (10.1)

14 Managing Tables

Additional Considerations for Direct-Path INSERTThe following are some additional considerations when using direct-path INSERT. Index Maintenance … with Direct-Path INSERT Oracle Database performs index maintenance at the end of direct-path INSERT … performed by the parallel execution servers for parallel direct-path INSERT or by the single process … for serial

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

F E mbedded SQL Statements and Directives

F.40 INSERT (Executable Embedded SQL)… Prerequisites For you to insert rows into a table, the table must be in your own schema or you must … have INSERT privilege on the table. For you to insert rows into the base table of a view, the owner of … the schema containing the view must have INSERT privilege on the base table. Also, if the view is

User's Guide and Reference, 10g Release 1 (10.1)

3 Loading Spatial Data

3.2 Transactional Insert Operations Using SQLthat the INSERT statement in Oracle SQL has a limit of 999 arguments. Therefore, you cannot create a … transactional INSERT statement; however, you can insert a geometry using a host variable, and the host … transactional insertions of geometries, you can create a procedure to insert a geometry, and then invoke

Administrator's Guide, 10g Release 1 (10.1)

14 Managing Tables

Advantages of Using Direct-Path INSERTThe following are performance benefits of direct-path INSERT: During direct-path INSERT, you can … disable the logging of redo and undo entries. Conventional insert operations, in contrast, must … table and then using direct-path INSERT operations, you update any indexes defined on the target table … during the

Administrator's Guide, 10g Release 1 (10.1)

8 Implementing Policy Enforcement Options and Labeling Functions

Evaluating Enforcement Control Options and INSERTWhen you attempt to insert or update data based on your authorizations, the outcome depends upon … what policy enforcement controls are active. If INSERT_CONTROL is active, then rows you insert can … compartments A and B, but you can only write to compartment A, then if you attempt to insert data with … on rows you insert.

Programmer's Guide, 10g Release 1 (10.1)

5 Binding and Defining in OCI

Providing INSERT or UPDATE Data at Runtimea Piecewise Insert or Update Once the OCI environment has been initialized, and a database … connection and session have been established, a piecewise insert begins with calls to prepare a SQL or PL … , populates a buffer with that piece, and then executes an insert. When the last piece has been inserted … , the operation is complete.

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

6 Statement Caching

Allocate Insert Into Cache Retrieve From CacheTable 6-1 Comparing Methods Used in Statement Caching Allocate Insert Into Cache Retrieve From