Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rename a column that had a reserved word
On Apr 16, 8:19 am, "RJ" <ridwan.je..._at_gmail.com> wrote:
> Hi All,
>
> How do I rename a column that has a reserved word?
> E.g. I have a table with a column named 'Date'
>
> Thanks in Advance!!
Try placing the column name in double quotes. Pull the column name from dba_tab_columns and use exact case when using double quotes in your ALTER statement.
HTH -- Mark D Powell -- Received on Mon Apr 16 2007 - 09:02:06 CDT
![]() |
![]() |