OraFAQ Forum: SQL & PL/SQL » how to copy table content from one to another with order

Home » SQL & PL/SQL » SQL & PL/SQL » how to copy table content from one to another with order

Tue, 05 March 2002 20:17

wangshitao
Messages: 3
Registered: March 2002

Junior Member

Hello

I have question: If I can copy the content from table A to Table B with order and some where in one single statement

Tue, 05 March 2002 20:57

seng
Messages: 191
Registered: February 2002

Senior Member

using these

1. CREATE TABLE tablename AS SELECT * FROM tablename1.

2. INSERT INTO tablename SELECT * FROM tablename1.

Hope this is helping.

Previous Topic:	Before Insert Trigger !!!!!!!
Next Topic:	catproc.sql

Goto Forum:

]

Current Time: Fri Apr 19 17:43:03 CDT 2024