dbms_metadata.get_ddl is returning the wrong ddl for some views
dbms_metadata.get_ddl is returning the wrong ddl for some views with the where clause imediatly following the 'AS' keyword
select * from dba_views where owner = 'SAMSDV2' and view_name = 'INCIDENT';
select dbms_metadata.get_ddl('VIEW','INCIDENT','SAMSDV2') from dual;
The output of the definition is as follows.
SQL> select dbms_metadata.get_ddl('VIEW','INCIDENT','SAMSDV2') from dual;
CREATE OR REPLACE FORCE VIEW "SAMSDV2"."INCIDENT" ("ACTLABCOST", "ACTLABHRS",
"ACTUALCONTACTDATE", "ACTUALFINISH", "ACTUALSTART", "AFFECTEDDATE", "AFFECTEDEMA
IL", "AFFECTEDPERSON", "AFFECTEDPHONE", "ASSETNUM", "ASSETORGID", "ASSETSITEID",
"CALCCALENDAR", "CALCORGID", "CALCSHIFT", "CHANGEBY", "CHANGEDATE", "CINUM", "C
LASS", "CLASSSTRUCTUREID", "COMMODITY", "COMMODITYGROUP", "CREATEWOMULTI", "DESC
RIPTION", "EXTERNALRECID", "FAILURECODE", "FR1CODE", "FR2CODE", "GLACCOUNT", "GL
select * from dba_views where owner = 'SAMSDV2' and view_name = 'INCIDENT';
select dbms_metadata.get_ddl('VIEW','INCIDENT','SAMSDV2') from dual;
The output of the definition is as follows.
SQL> select dbms_metadata.get_ddl('VIEW','INCIDENT','SAMSDV2') from dual;
CREATE OR REPLACE FORCE VIEW "SAMSDV2"."INCIDENT" ("ACTLABCOST", "ACTLABHRS",
"ACTUALCONTACTDATE", "ACTUALFINISH", "ACTUALSTART", "AFFECTEDDATE", "AFFECTEDEMA
IL", "AFFECTEDPERSON", "AFFECTEDPHONE", "ASSETNUM", "ASSETORGID", "ASSETSITEID",
"CALCCALENDAR", "CALCORGID", "CALCSHIFT", "CHANGEBY", "CHANGEDATE", "CINUM", "C
LASS", "CLASSSTRUCTUREID", "COMMODITY", "COMMODITYGROUP", "CREATEWOMULTI", "DESC
RIPTION", "EXTERNALRECID", "FAILURECODE", "FR1CODE", "FR2CODE", "GLACCOUNT", "GL
0