Re: Oracle 8 SQL

No easy way as far as i know.
You will need to create a temp table with the unique Id of the original table plus the column you want to update.

create table temp_table as
select <unique_id>, <field_to_be_changed> from table;

Delete all data in field

update <table>
set <field_to_be_changed> = null;

Change datatype

alter table <table>
modify <field_to_be_changed> varchar2(???);

Reload data back from temp table into field using a cursor loop of some sort.

HTH Mark

susanne mainz wrote in message <7jinfe$l2c$1_at_news.hamburg.pop.de>...
>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
>
>
Received on Tue Jun 08 1999 - 04:37:09 CDT