SQL Plus - Copy command

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

Copies data from a query to a table in the same or another database. COPY supports CHAR, DATE, LONG, NUMBER and VARCHAR2.

3 - Syntax

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

where database has the following syntax:

  • username[/password]@connect_identifier
Advertising
lang/sqlplus/copy.txt · Last modified: 2017/05/09 16:51 by gerardnico