Re: Changing an object - alter?

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/11/26
Message-ID: <19971126235101.SAA09754@ladder02.news.aol.com>#1/1

>The Problem is that when I imported the
>data the two field that were supposed to be "NUMBER," actually turned out to
>be CHAR(50) fields. How do I change the objects in these two columns from
>CHAR to NUMBER? Is it the "alter table" command?

Hi

Yes and no!
alter table junk modify junk_column number is fine.

BUT you can only modify the datatype if the column is NULL in ALL records.

John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

Received on Wed Nov 26 1997 - 00:00:00 CST