Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating a table while loading data into it - possible?

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

From: Dave Baker <newsgroup_poster_at_jodael.com>
Date: Sun, 09 Apr 2006 21:17:46 +0800
Message-ID: <jb1i329lhui8ovro5n7bunpikp8ieutveq@4ax.com>


On Sun, 09 Apr 2006 14:13:28 +0200, Moritz Klein <mklein_at_students.uni-mainz.de> wrote:

>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>;

Sounds like this should be the basis of the solution.

Only problem here that I can see is how to get <old_table> from VB to be recognised by Oracle. Normally in VB one does something like this:

strSQL = "create table <new_table>"
dbtemp.Execute strSQL, dbFailOnError

So, all parts of the SQL string have to be string values or be converted to string values...not sure I can do that with a whole table.

Dave Received on Sun Apr 09 2006 - 08:17:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US