INSERT zero or more rows into a table in the remote database
This operation is implemented in the following versions
|
This example was developed using Oracle 9.2.0.1 on Windows 2000
This example requires the following table definition in a remote database
CREATE TABLE t1 (c1 NUMBER);
The table does not need to be analysed
The statement
INSERT INTO t1@database@link VALUES (0);
generates the following execution plan
0 INSERT STATEMENT (REMOTE) Optimizer=CHOOSE