Re: Rename Table name in Oracle 8i

In ordinary sql it's
rename table <table_a> to <table_b>.
For ex-sql server rookies, who seem to do _everything_ in stored procedures it's (within pl/sql)
execute immediate 'rename table ... etc ';

Hth,

Sybrand Bakker, Oracle DBA

J Gao <jie.gao_at_tequilasoftware.com> schreef in berichtnieuws TJLI4.6041$xz1.217361_at_cac1.rdr.news.psi.ca...
> Hi, There,
> Is there any easy way to rename the table name in Oracle 8i. In SQL Server
> 7, sP_rename stored procedure will do this job. I wonder if Oracle 8i has
> the similar one. Thanks.
>
> J Gao
>
>
Received on Tue Apr 11 2000 - 00:00:00 CDT