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 -> Change a column object

Change a column object

From: drichardson <rchrdson_at_ix.netcom.com>
Date: 1997/11/25
Message-ID: <65ghra$m4b@dfw-ixnews4.ix.netcom.com>#1/1

Hello,

I am fairly new to Oracle. I created a table in Oracle by importing a table from Access to Oracle. When the table was created however, two columns that should have been NUMBER columns turned out to be CHAR(50) columns. How do I convert these two columns from CHAR to NUMBER?

Any help would be greatly appreciated.

David Richardson
drichardson_at_altera.com Received on Tue Nov 25 1997 - 00:00:00 CST

Original text of this message

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