Re: SQL Developer - view DDL Formatting
- From: Fergal Taheny <ftaheny@xxxxxxxxx>
- To: "Powell, Mark" <mark.powell2@xxxxxxx>
- Date: Tue, 25 Apr 2017 21:47:04 +0100
I am of the opinion that views should always have an attribute list since
I have encountered views where the view column name does not match up to
the select list column names.
I have a different opinion on this. If I want the column names to differ I
use an alias in the select statement. The problem I see with the attribute
list is that it can get out of sync with the attributes in the select list.
I just dont see any good reason to use the attribute list.
Nor should a new column added to a table automatically appear in any views
defined on the table. The sensitivity of the column data has to be
considered in relation to the purpose and audience of each view that
references the table.
Agreed. I didn't say anything about automatically adding columns to views.
When the view is updated you can easily generate the view code from the
RDBMS Dictionary or using DBMS_METADATA.
Yes thanks but I was just trying to figure out if SQL Developer Database
export could do this for me.
Other related posts: