Re: Renaming a column

Bastien,

For Oracle you need to use 'CREATE TABLE AS SELECT' clause.

Chris

bastien.piroue_at_gsi-office.de wrote:
>
> Hello,
>
> I want
> a) to change the datatype of a column of a table
> b) to change the name of a column of a table.
>
> I want this for Oracle7, Oracle8 and MS-SQL-Server 6.5 and MS_SQL - Server 7.
> The tables are in use, so that there are rows in it, that the alter table
> alter column - command of ORACLE fails. Any tools, suggestions?
>
> Thank you for any help!
>
> Bastien Piroué, Germany
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
  Received on Wed Jan 27 1999 - 00:00:00 CST