Women in Technology

Hear us Roar



Article:
  SQL Data Types
Subject:   Ora Data Conversion
Date:   2003-06-30 02:39:18
From:   anonymous2
Hi,


I have a problem of converting LONG data type to varchar2 in a table. So I need to create a new table by using the max varchar2(4000) instead of the long defined in the current tables.


The round-about solution is to have a cursor for the table and then insert into a new table with varchar2(4000) data.


But is there any other standard / easy way available?


Table details :
CURRENT:


STATUS CHAR(1),
SEQ_NO NUMBER(10),
DATA LONG


I need to convert this "DATA" field into VARCHAR2(4000).


Thx for the early reply.


Cheers,
Avinash