Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to change column names?

Re: How to change column names?

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/09/21
Message-ID: <6u7746$7s@dfw-ixnews5.ix.netcom.com>#1/1

No, alter table cannot change a column's name. I remember someone post on the group saying that you can change a data dictionary view (ts$ ?), but I never brave enough to try!

Winnie

badstreetboy_at_my-dejanews.com wrote in message <6u6t6v$a2b$1_at_nnrp1.dejanews.com>...
>I know 'alter table' can add column or change datatype of a column. But
 can
>it change column name?
>
>Thanks..
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Sep 21 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US