-----Original Message-----
Subject:	Oracle problem

Dear Mr. Akaplan,
    Hi, How are you doing? I wonder how do you copy the data from one
table to another using Oracle 8.0.4 . Thank you!

Yours faithfully,
Kinny


----------------- Reply -------------------
Kinny,

Assume you have TABLE_A with data, and TABLE_B without data:
TABLE_A
--------------
NAME		VARCHAR2(50)
ADDRESS	VARCHAR2(50)
CITY		VARCHAR2(30)
STATE		CHAR(2)
PHONE		VARCHAR2(20)

TABLE_B
--------------
NAME		VARCHAR2(50)
PHONE		VARCHAR2(20)

To get the name and phone information from TABLE_A to TABLE_B, issue the following SQL:

INSERT INTO TABLE_B (NAME, PHONE) SELECT NAME, PHONE FROM TABLE_A;

Best regards,

-Ari Kaplan

Back to Ari Kaplan's Home Page ack to Ari Kaplan's Home Page