Re: Q: How to rename columns?

Ken Johnson wrote:
>
> There is a way to rename users and columns (tables too but why), but its
> unsupported, undocumented, evil, fattening, etc. It uses the USER$, TABLE$, & COL$
> tables. You can check look in the Oracle FAQ at:
> ftp://ftp.bf.mit.edu.au/pub/Oracle/FAQ/orafaqwww.zip for more details.
>
> But there is no nice, clean, supported way to rename Users or Columns. (You can
> rename tables with 'RENAME oldname TO newname')
>
> Ken Johnson

Ken made a minor typo. The FAQ is at:
ftp://ftp.bf.rmit.edu.au/pub/Oracle/FAQ/orafaqwww.zip

             ^

-- 
==============================================================================
Jason Wells                 Tapestry Computing, Inc.       Voice: 314.344.0066
Senior Software Developer   Email:jason.wells_at_tapestry.com   Fax: 314.344.0990
==============================================================================