SQL Developer - view DDL Formatting

From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Tue, 25 Apr 2017 14:51:00 +0100
Message-ID: <CAOuMUT5kjU_Trj-ifmz02JnSxnvG3io+DZUZ5+Lu0bBNpGok2w_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 25 2017 - 15:51:00 CEST

Original text of this message