SQL Developer - view DDL Formatting

  • From: Fergal Taheny <ftaheny@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 25 Apr 2017 14:51:00 +0100

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

Other related posts: