create or replace view shows view column names automatically

Hi,
I've enabled a setting and I can't for the life of me figure out which.
Now, when I edit a view, it automatically puts the column names as part of the declaration at the top. I don't want this.

e.g.
create or replace myview
(col1, col2, col3)
as
select 1, 2, 3 from dual;

Can anyone tell me what the setting is to disable this wonderful feature?
Thanks
Matt.
 
You can go to Tools > Preferences > Oracle / Options and set the "Add column alias list for View DDL" option to "Auto" or "Never".
 
Back
Top