Re: Q: How to rename columns?

From: Ken Johnson <kjohnson_at_mo.net>
Date: 1996/05/27
Message-ID: <31AA4F8E.6112_at_mo.net>#1/1

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 Received on Mon May 27 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: r.schipper_at_pi.net: "Re: Transferring Access data to Oracle"
Previous message: Peter Headland: "Re: Please recommend me a DB!"
In reply to: Alexander Delnef: "Q: How to rename columns?"
Next in thread: Yves Bergeron: "Re: How to issue CREATE USER command from a stored proc?"
Reply: Jason Wells: "Re: Q: How to rename columns?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message