Skip to content

Instantly share code, notes, and snippets.

@oguzhankircali

oguzhankircali/typeToClob.sql

Created April 3, 2019 14:39
Show Gist options
  • Save oguzhankircali/128ef0a1ccde39dbac4c5667776b91fa to your computer and use it in GitHub Desktop.
Save oguzhankircali/128ef0a1ccde39dbac4c5667776b91fa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
typeToClob.sql
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment