Can I convert existing column BLOB to CLOB?
718371Nov 20 2012 — edited Nov 21 2012Hi ,
I need conversion of existing column from BLOB to CLOB. Kindly sueggest workaround. Table structure is as
{ desc tab1;
Name Null? Type
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NOT NULL VARCHAR2(255)
XMLRECORD BLOB}
I need to convert it from blob to clob. Kindly provide workaround.
Regards