Re: Oracle 8 SQL

From: <shiling_at_math.wayne.edu>
Date: Sat, 12 Jun 1999 23:02:44 GMT
Message-ID: <7juoug$jav$1@nnrp1.deja.com>

Yes, you sure do. If there is nothing wrong with the data, you may create a temp table with the key values and the values of the column you want to change its data type. You can easily to reload the data into changed table later on.

SQL> desc t1

 Name                            Null?    Type
 ------------------------------- -------- ----
 TESTDATE1                                DATE

SQL> update t1
2 set testdate1=null;

1 row updated.

SQL> alter table t1
2 modify (testdate1 varchar2(10));

Table altered.

In article <7jinfe$l2c$1_at_news.hamburg.pop.de>, "susanne mainz" <smainz_at_debis.com> wrote:
> Hi there,
> is there a possibility to delete a column's content from a table? I
need to
> change the datatype of this very column and I can't do so since there
is
> already data in it...
> Susanne
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 12 1999 - 18:02:44 CDT