I don’t think DBMS_METADATA offers a flag for that preference, so the short
answer is ‘no.’
You could create a custom report though and build the DDL code yourself, and
attach that as a tab in the View editor.
From: Fergal Taheny [mailto:ftaheny@xxxxxxxxx] ;
Sent: Tuesday, April 25, 2017 9:51 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: SQL Developer - view DDL Formatting
Hi,
When using “Database Export” in SQL Developer, does anyone know if there is a
way get the DDL for views to look like this:
CREATE OR REPLACE VIEW “X” AS
select
A,
B,
C
from
D;
instead of this:
CREATE OR REPLACE VIEW “X” (“A”,”B”,”C”) AS
select
A,
B,
C
from
D;
i.e. I don’t want the attribute list to appear.
Thanks,
Fergal
