Re: Help Please...

From: Tony Hunt <tonster_at_bigpond.net.au>
Date: Sat, 22 Sep 2001 01:19:42 GMT
Message-ID: <OGRq7.77896$bY5.376235@news-server.bigpond.net.au>

CREATE TABLE newtable AS (SELECT * FROM oldtable)

"Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message news:1000477584.656157_at_nntp.accessus.net...
> Hi,
>
> In Microsoft SQL server to rename an existing table I would call a system
> stored proc sp_rename <table name>, <new tabe name>. Can I rename a
table
> in Oracle? If so could somebody please provide an example.
>
> Thanks,
> --
> Rob Panosh
> Advanced Software Designs
>
>
>
>
Received on Fri Sep 21 2001 - 20:19:42 CDT