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 -> Renaming Columns 8i

Renaming Columns 8i

From: <richl796_at_my-deja.com>
Date: Fri, 30 Jul 1999 14:35:26 GMT
Message-ID: <7nsd7d$gbn$1@nnrp1.deja.com>


I'm trying to rename a column in a table and can't find the syntax for it in the
documentation. I'm running 8i so I know this is new functionality that has been added for this release. I'm trying to move a long datatype from one table to another using the sql*plus copy command but the column names have to be the same on both tables. So I'll have to move the data then rename unless there is an easier way I don't know about.

Thanks,

-Rich

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 30 1999 - 09:35:26 CDT

Original text of this message

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