Re: Oracle 8 - Renaming Coulmns

On 8 Jun 2006 12:09:36 -0700, "amerar_at_iwc.net" <amerar_at_iwc.net> wrote:

>So, I just want to see if there is a non-documented way to do it, and,
>explain to the client the dangers of doing it his way........I can only
>suggest the ways to do it. The client makes the decision.......
>
>Is COL$ the only table that would have to change?
>
>Thanks!

Each record in each table has an internal column directory. There are no column names in that directory, it fully relies on the order of the columns in the dictionary.
See what I'm getting at?
Even if you would manage to screw up the col$ table correctly, how are you going to rearrange all affected records?

Also using * is bad programming practice, especially in Pl/sql, as any change to the table invalidates all the statements based upon it.

--
Sybrand Bakker, Senior Oracle DBA