Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating table in db2 using AS option

843854Nov 6 2004 — edited Jan 13 2005

hello,

i am new to DB2 ...i need a direct query for creating a new table from the existing table along with
the structure and the data....
the similler query in oracle is
create table <newtable> as (select * from oldtable)...
please help...
thanks in advance ...
ullas kumar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2005
Added on Nov 6 2004
5 comments
507 views