Re: Creating a table while loading data into it - possible?

Dave Baker schrieb:
> I'm using VB to load data from one Access table into a destination table.

> What I want to do now is to make the destination table an Oracle table.
> Is it possible to do the same thing with one command for Oracle?

Yes.

create table <new_table> as select * from <old_table>;

hth,
  Moritz Received on Sun Apr 09 2006 - 07:13:28 CDT