Changing a column
From: Nimrod Oren <nimrodo_at_vocaltec.com.nospam>
Date: Tue, 21 Apr 1998 15:13:01 GMT
Message-ID: <353cb5f4.5159937_at_news.netvision.net.il>
Date: Tue, 21 Apr 1998 15:13:01 GMT
Message-ID: <353cb5f4.5159937_at_news.netvision.net.il>
On 21 Apr 1998 06:45:18 GMT, "Sbaiz" <pierluigi.sbaiz_at_elsag.it> wrote:
>Hi to all
>is there a way, in Oracle, to modifiy a column name without dropping the
>table
>maintaining its data. I know that others databases permit changing the name
>of
>the column or dropping a column, but Oracle not.
>It would be nice if Oracle can modify the column name or generate the
>scripts
>by itself, taking care of all the constraints.
>
>Thanks in advance.
>Pierluigi S.
Try CREATE AS SELECT and then rename the tables, or use SQL*LOAD to
load to a new table.
Nimrod Received on Tue Apr 21 1998 - 17:13:01 CEST