6 Replies Latest reply on Jan 17, 2010 6:59 PM by 737819

    procedure to convert from long to clob

    746134
      please need to procedure migrate data from long to clob,with variables
      V_SRC_TABLE (LONG) to V_TRAGT_TABLE (CLOB)

      SOURCE AND TARGET TABLE HAVE TWO COLUMNS

      SOURCE_TABLE
      VARACHAR2
      LONG


      TARGET_TABLE
      VARACHAR2
      CLOB