INSERT Statement

Add data to a table, view, or snapshot.

Syntax:

   INSERT [hint] INTO [schema.] table [@dblink] [t_alias] (column, column,...)
      VALUES (expression)

   INSERT [hint] INTO [schema.] table
      [[SUB]PARTITION (ptn_name)] [t_alias] (column, column,...)
         VALUES (expression)

   INSERT [hint] INTO subquery 
      WITH [READ ONLY | CHECK OPTION [CONSTRAINT constraint] ]
         [t_alias] (column, column,...)
            VALUES (expression)

VALUES(expression) can be expanded to

   VALUES ([expr, expr...] [subquery])
     [RETURNING expr, expr... INTO host_variable|plsql_variable]

In the syntax above "table" can be replaced with "view" or "snapshot"

Related Commands:

DELETE
EXPLAIN PLAN
SELECT

TRUNCATE

UPDATE

Related Views:

  DBA_SNAPSHOTS        ALL_SNAPSHOTS        USER_SNAPSHOTS 
  DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
  DBA_TABLES           ALL_TABLES           USER_TABLES         TAB
  DBA_VIEWS            ALL_VIEWS            USER_VIEWS
                                                                DICTIONARY
                                                                DICT_COLUMNS



Back to the Top

Simon Sheppard
SS64.com