create tabe a as select * from b;
drop table b;
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> schrieb im
Newsbeitrag news:3c7a180f$0$232$ed9e5944_at_reading.news.pipex.net...
> you can do this using a sp in Oracle moreover you could pass the table
name
> as a parameter name to the procedure. However almost certainly you don't
> want to. what is the underlying reason for creating the table using an SP
in
> the first place?
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Dave K" <randave_at_optonline.net> wrote in message
> news:e7Od8.37402$co1.6824229_at_news02.optonline.net...
> > I use VB with ADO 2.5 to connect to a database that could be Access
2000,
> > SQL Server, or Oracle. A stored procedure creates a table, and then I
> need
> > to change the name of that table.
> >
> > Is there a good way to do this in code, or can I do this with a
> query/stored
> > procedure for each database?
> >
> > Thanks!
> >
> > - Dave
> >
> >
>
>
Received on Sun Mar 10 2002 - 10:32:20 CST
