Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rename table with vb code
rename a to b;
this is also a probable solution. could pass a and b as arugments to a procedure call in the database and coudl execute this stmt in the procedure.
Thorsten Hoefer wrote:
> 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
> > >
> > >
> >
> >
-- Atul Agrawal | Atul Agrawal Masters Student, CS Deptt. | 3501, St Paul Street, Johns Hopkins University | Apt # 1018, 3400, N Charles Street, NEB 224 | Baltimore, Baltimore, MD 21218. | MD 21218. | Hello: 410-516-8291 (Lab) | Hello: 410-366-6852 (Resi)Received on Mon Mar 11 2002 - 17:31:08 CST
![]() |
![]() |