oguzhankircali
4/3/2019 - 2:39 PM

nvarchar or string to clob script

ALTER TABLE sgl.AUDIT_LOGS ADD (PARAMETERS_TEMP  CLOB);

UPDATE sgl.AUDIT_LOGS SET PARAMETERS_TEMP=PARAMETERS;

ALTER TABLE sgl.AUDIT_LOGS DROP COLUMN PARAMETERS;

ALTER TABLE sgl.AUDIT_LOGS RENAME COLUMN PARAMETERS_TEMP TO PARAMETERS;