Adding ";" to DBMS_METADATA_DIFF.COMPARE_ALTER output
CREATE TABLE t1 ( sr number(10), sdata VARCHAR2(30) );
CREATE TABLE t2 ( sr number(9) not null, sdata1 VARCHAR2(20), sdatax CLOB );
set long 20000
col cmd form a132 word_wrapped
select dbms_metadata_diff.compare_alter ( 'TABLE', 'T1', 'T2', USER, USER ) cmd from dual;
Result:
ALTER TABLE "TESTSR"."T1" ADD ("SDATA1" VARCHAR2(20))
ALTER TABLE "TESTSR"."T1" ADD ("SDATAX" CLOB) LOB ("SDATAX") STORE AS BASICFILE ( TABLESPACE "MATCHING_DATA" ENABLE STORAGE IN ROW
CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS
1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
ALTER TABLE "TESTSR"."T1" DROP ("SDATA")
ALTER TABLE "TESTSR"."T1" MODIFY ("SR" NUMBER(9,0))