Re: rename colunm

You need to rename the table, create a table with the proper column names, then copy the data from the old table to the new table. There is no column rename or delete in Oracle.

hpcheong_at_ncs.com.sg wrote in message <6t7smp$th4$1_at_nnrp1.dejanews.com>...
>hi all,
>
>i am trying to rename a colunm name from sch to school,
>
>note: there's data in this field and i want to retain the data
>
>what is the syntax to do it
>
Received on Sun Sep 20 1998 - 10:34:35 CDT