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