Sql script that converts one column from varchar to clob.

from_varchar_to_clob.sql

ALTER TABLE NP_SUSP_TRANS_REP ADD ("REASONS_REMIT_BREACH_N" CLOB NULL) LOB
  (
    "REASONS_REMIT_BREACH_N"
  )
  STORE AS
  (
    TABLESPACE "notif_dat" RETENTION ENABLE STORAGE IN ROW NOCACHE
  );
UPDATE NP_SUSP_TRANS_REP SET "REASONS_REMIT_BREACH_N" = "REASONS_REMIT_BREACH";
-- ALTER TABLE "ARIS_STG".trs_fund_storage_unavail MODIFY ("unavailabilityDescrN" NOT NULL);
ALTER TABLE NP_SUSP_TRANS_REP DROP COLUMN "REASONS_REMIT_BREACH"; 
ALTER TABLE NP_SUSP_TRANS_REP RENAME COLUMN "REASONS_REMIT_BREACH_N" TO "REASONS_REMIT_BREACH";

ALTER TABLE NP_SUSP_TRANS_REP ADD ("REMARKS_INSIDE_INFO_DISCLOSURE_N" CLOB NULL) LOB
  (
    "REMARKS_INSIDE_INFO_DISCLOSURE_N"
  )
  STORE AS
  (
    TABLESPACE "notif_dat" RETENTION ENABLE STORAGE IN ROW NOCACHE
  );
UPDATE NP_SUSP_TRANS_REP SET "REMARKS_INSIDE_INFO_DISCLOSURE_N" = "REMARKS_INSIDE_INFO_DISCLOSURE";
-- ALTER TABLE "ARIS_STG".trs_fund_storage_unavail MODIFY ("unavailabilityDescrN" NOT NULL);
ALTER TABLE NP_SUSP_TRANS_REP DROP COLUMN "REMARKS_INSIDE_INFO_DISCLOSURE"; 
ALTER TABLE NP_SUSP_TRANS_REP RENAME COLUMN "REMARKS_INSIDE_INFO_DISCLOSURE_N" TO "REMARKS_INSIDE_INFO_DISCLOSURE";