4 Replies Latest reply: Nov 21, 2012 2:40 AM by Osama_Mustafa RSS

    Can I convert existing column BLOB to CLOB?

    718371
      Hi ,

      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