|Oracle® Database SQL Language Reference 11g Release 2 (11.2)
|PDF · Mobi · ePub| INSERT statement to add rows to a table, 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. 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 containing the view must have the INSERT object privilege
on the base table. Also, if the view is in a schema other than
your own, then you must have the INSERT object privilege on the
view. If you have the TABLE system privilege, then you can also
insert rows into any table or the base table of any view. You
must also have the SELECT object privilege on the table into
which you want to insert rows if the table is on a remote
database. You can use the INSERT statement to insert data into a
table, partition, or view