Re: Change a column object

From: CarlMal <malazdre_at_cn.ca>
Date: 1997/11/26
Message-ID: <347C5AC5.278FE39B@cn.ca>#1/1

I'm assuming you exported the Access data to an ascii file and used SQLLoader to load the data into Oracle. Probably easier is to create the Oracle table 1st with the correct data types and then use an append query within Access to load the data.

drichardson wrote:

> 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 Wed Nov 26 1997 - 00:00:00 CST