SQLPlus Copy

COPY Command Syntax:

COPY {FROM database TO database} {APPEND|CREATE|INSERT|REPLACE}
destination_table [(column, column, column, …)] USING query

database = username[/password]@database_name

COPY Command Examples:

COPY FROM scott/[email protected]_1 TO mike/[email protected]_2
REPLACE dba_2.customers
USING SELECT * FROM dba_1.customers

COPY FROM scott/[email protected]_1
CREATE new_products (product_id, product_name, price)
USING SELECT product_id, description, price FROM products
WHERE product_status=’NEW’;