Copy Command-copy data from one database to another database

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

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

Example:

copy from hr/hr@orcl to hr/hr@orcl insert emp2 using select * from emp;

copy from hr/hr@orcl to scott/tiger@orcl insert abc using select * from employees;

copy from hr/hr@orcl to scott/tiger@orcl create dep_id (dep_id,dep_name,man_id,loc_id) using select * from departments;

copy from hr/hr@orcl to scott/tiger@orcl replace employee using select * from employees;

RESERVED WORDS (PL/SQL)-Oracle 10g

 An asterisk (*) indicates words are also SQL Reserved Words.

 ALL*                                                     DESC*                   JAVA                          PACKAGE             SUBTYPE

 ALTER*                                                 DISTINCT*          LEVEL*                       PARTITION          SUCCESSFUL*

 AND*                                                    DO                         LIKE*                          PCTFREE*            SUM

 ANY*                                                     DROP*                 LIMITED                    PLS_INTEGER      SYNONYM*

 ARRAY                                                 ELSE*                    LOCK*                        POSITIVE              SYSDATE*

 AS*                                                        ELSIF                     LONG*                      POSITIVEN           TABLE*

 ASC*                                                     END                      LOOP                          PRAGMA              THEN*

 AT                                                          EXCEPTION         MAX                           PRIOR*                 TIME

 AUTHID                                               EXCLUSIVE*      MIN                          PRIVATE               TIMESTAMP

 AVG                                                      EXECUTE              MINUS*                   PROCEDURE       TIMEZONE_ABBR

 BEGIN                                                   EXISTS*               MINUTE                    PUBL IC*            TIMEZONE_HOUR

 BETWEEN*                                          EXIT                      MLSLABEL*              RAISE            TIMEZONE_MINUTE

BINARY_INTEGER  EXTENDS         MOD                    RANGE                      TIMEZONE_REGION

BODY                                                     EXTRACT              MODE*                      RAW*                TO*

 BOOLEAN                                            FALSE                   MONTH                      REAL                 TRIGGER*

 BULK                                                    FETCH                   NATURAL                  RECORD          TRUE

 BY*                                                       FLOAT*                NATURALN              REF                    TYPE

 CHAR*                                                 FOR*                     NEW                           RELEASE            UI

 CHAR_BASE                                       FORALL                 NEXTVAL                  RETURN            UNION*

 CHECK*                                               FROM*                 NOCOPY                   REVERSE           UNIQUE*

 CLOSE                                                  FUNCTION          NOT*                         ROLLBACK        UPDATE*

 CLUSTER*                                           GOTO                    NOWAIT*                 ROW*               USE

 COALESCE                                          GROUP*              NULL*                        ROWID*           USER*

 COLLECT                                              HAVING*            NULLIF                       ROWNUM*      VALIDATE*

 COMMENT*                                      HEAP                     NUMBER*                ROWTYPE         VALUES*

 COMMIT                                             HOUR                    NUMBER_BASE      SAVEPOINT       VARCHAR*

 COMPRESS*                                      IF                            OCIROWID               SECOND          VARCHAR2*

 CONNECT*                                                        IMMEDIATE*      OF*                           SELECT*             VARIANCE

 CONSTANT                                                        IN*                         ON*                           SEPERATE          VIEW*

 CREATE*                                              INDEX*                OPAQUE                   SET*                  WHEN

 CURRENT*                                       INDICATOR           OPEN                         SHARE*             WHENEVER*

 CURRVAL                                          INSERT*                 OPERATOR               SMALLINT*       WHERE*

 CURSOR                                           INTEGER*               OPTION*                  SPACE                 WHILE

 DATE*                                               INTERFACE             OR*                            SQL                     WITH*

 DAY                                                   INTERSECT*            ORDER*                   SQLCODE            WORK

 DECIMAL*                                     INTERVAL        ORGANIZATION              SQLERRM         WRITE

 DECLARE                                       INTO*               OTHERS                               START*               YEAR

 DEFAULT*                                     IS*                    OUT                                       STDDEV             ZONE

 DELETE*                                        ISOLATION

RESERVED WORDS (SQL)-Oracle 10g

An asterisk (*) indicates words are also ANSI Reserved Words.

                                                                            

ACCESS                   DEFAULT*              INTEGER*              ONLINE                  START

 ADD*                     DELETE*                  INTERSECT*         OPTION*               SUCCESSFUL

 ALL*                       DESC*                      INTO*                     OR*                       SYNONYM

 ALTER*                 DISTINCT*             IS*                         ORDER*                SYSDATE

 AND*                    DROP*                   LEVEL*                     PCTFREE                TABLE*

 ANY*                    ELSE*                      LIKE*                         PRIOR*                  THEN*

 AS*                       EXCLUSIVE               LOCK                      PRIVILEGES*         TO*

 ASC*                    EXISTS                        LONG                     PUBLIC*                TRIGGER

 AUDIT                  FILE                             MAXEXTENTS      RAW                     UID

 BETWEEN*        FLOAT*                      MINUS                  RENAME             UNION*

 BY*                       FOR*                          MLSLABEL            RESOURCE          UNIQUE*

 CHAR*                 FROM*                     MODE                     REVOKE*             UPDATE*

 CHECK*               GRANT*                   MODIFY               ROW                     USER*

 CLUSTER             GROUP*                  NOAUDIT            ROWID                  VALIDATE

 COLUMN            HAVING*                NOCOMPRESS    ROWNUM           VALUES*

 COMMENT        IDENTIFIED              NOT*                     ROWS*               VARCHAR*

 COMPRESS        IMMEDIATE*         NOWAIT              SELECT*             VARCHAR2

 CONNECT*        IN*                          NULL*                  SESSION*           VIEW*

 CREATE*             INCREMENT          NUMBER             SET*                   WHENEVER*

 CURRENT*        INDEX                     OF*                         SHARE                WHERE

 DATE*                  INITIAL                   OFFLINE                SIZE*                  WITH*

 DECIMAL*          INSERT*                 ON*                        SMALLINT*