bulk insert.

[lovekang]

I have two tables with the same stucture, one difference is the name of them.

how can I copy data from tableA to tableB?

is there a query like;
insert into tableB values (*) select * from tableA?

I NEED A QUERY STATEMENT.

Thanks.

 

[lovekang]

as in SQL Server like;
INSERT INTO TABLE2 SELECT * FROM TABLE1

 

[Thargy]

lovekang,

the syntax is exactly as sql server.
Run the following code

CREATE TABLE lovekang
      (
	  dummy1 VARCHAR2(10)
	  );

--Make a copy of lovekang
CREATE TABLE LOVEKANG2 AS SELECT * FROM LOVEKANG;
	  
INSERT INTO lovekang VALUES ('lovekang1');
INSERT INTO lovekang VALUES ('lovekang2');
INSERT INTO lovekang VALUES ('lovekang3');

SELECT * FROM lovekang2;

INSERT INTO lovekang2 SELECT * FROM lovekang;
COMMIT;

SELECT * FROM lovekang2;

DROP TABLE lovekang2;
DROP TABLE lovekang;

As you will see from the select statement, after the insert, you will get three rows returned. QED.

Regards

Tharg

Grinding away at things Oracular

 

[lovekang]

Thanks.
I was confused by something at that time.