All,

I need help editing Oracle views in Squirrel SQL.

Problem: The object tree's source tab for an Oracle view does not list the column names.

Question: How do I get Squirrel to show me the column names with the view definition?

example:
--the following view definition
create or replace view X_RV_EXAMPLE
 ("EXAMPLE_NAME")
as select name from x_example_list
;

--would show in Squirrel's object tree source tab as:
create or replace view X_RV_EXAMPLE
as select name from x_example_list
;

I cannot find a 'Edit View' or 'Script View' option. I assume you need to copy and paste from the source tab to edit the view.

I greatly appreciate everyone's time and attention.

Regards,


Chuck Boecking
512.699.0014