Just a thought ...... if you wanted a copy of the unadulterated VIEW source
code outside of SQL Developer, you could just query ALL_VIEWS
~
Mike
On 25 Apr 2017, at 15:59, Jeff Smith <jeff.d.smith@xxxxxxxxxx> wrote:
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 ;<mailto:ftaheny@xxxxxxxxx>]
Sent: Tuesday, April 25, 2017 9:51 AM
To: oracle-l@xxxxxxxxxxxxx <mailto: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
