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
Subject: SQL Developer - view DDL Formatting
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
instead of this:
CREATE OR REPLACE VIEW “X” (“A”,”B”,”C”) AS
i.e. I don’t want the attribute list to appear.