Have searched for answers on this forum, unable to find the specific answer. Apologies if I missed it.
Issue: Using the Describe Objects feature (clicking F4 on view name) and Script (with Views > Format UNCHECKED), results in:
Create or replace view X_view
(column_1,column_2,column_3)
as
select
– header comment1
– header comment2
x1 column_1,
x1 column_2,
x1 column_3
from table;
**What I need: **
Create or replace view X_view
(column_1,
column_2,
column_3)
as
select
– header comment1
– header comment2
x1 column_1,
x1 column_2,
x1 column_3
from table;
If Format is CHECKED then the column names are aligned as desired, but the content of the select statement are skewed all over the place (i.e., the comments, and many of the lines are split into separate lines).
Create or replace view X_view
(column_1,
column_2,
column_3)
as
select
– header comment1
– header comment2
x1
column_1,
x1
column_2,
x1
column_3
from table;
In Toad for Oracle 12.10.0.30, I was able to leave the Format option CHECKED, and the format came out formatted like this:
Create or replace view X_view
(column_1,
column_2,
column_3)
as
select
– header comment1
– header comment2
x1 column_1,
x1 column_2,
x1 column_3
from table;
Any hints are appreciated. It is very difficult to read the views in my current Toad version.