Term: INSERT

Definition:
In Oracle PL/SQL, an INSERT statement adds one or more records to any single table in a relational database. The INSERT statement may also be used add rows to the base table of a view, a partition of a partitioned table or a subpartition of a composite-partitioned table, or an object table or the base table of an object view.

Basic INSERT Example:

INSERT INTO users

(first_name, last_name)

VALUES

('john', 'smith');

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.

Related Links:

The Oracle INSERT Statement

Related Code Snippets:

INSERT - Examples of INSERT statements.
FORALL Insert - FORALL transfers data from a PL/SQL collection to the specified table using collec...
INSERT: Single Column Table Or View - Simple single table/column SELECT examples.
INSERT: Multiple Column Table Or View (All Columns) - Simple insert examples (multiple column ins...
INSERT: Multiple Column Table Or View (Not all columns) - INSERT example with multiple columns, t...
INSERT with Select - Basic Insert with Select example with a subquery.
INSERT: Using A Record - Insert by Using RECORD Type Variable.
INSERT WHEN - The insert when command can do a conditional insert. There are 2 modes for condi...
INSERT ALL - You can use the INSERT ALL statement without a condition. This provides you with mult...
INSERT ALL WHEN - If you specify ALL, the default value, then the database evaluates each WHEN cla...
INSERT FIRST WHEN - The WHEN clause is evaluated in the order in which it appears in the statement...
INSERT WITH CHECK OPTION - The "WITH CHECK OPTION" is used to indicate that Oracle will prevent an...
Inserting into SELECT statement - You can use a select-statement within an INSERT statement to ins...
Create Table INSERT (CTAS) - Create a table with the results from a SELECT statement.
INSERT With Returning Clause - The RETURNING clause was implemented as part of the Oracle 10g rele...