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,
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-lReceived on Tue Apr 25 2017 - 15:51:00 CEST