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

Recommended for You
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >