I have created a login.sql script.
I have modified the preferences for the database - Filename for connection startup script - where the login.sql is located
I have placed the follow set statement in the login.sql
set wrap off - to stop the information from wrapping to the next line
set linesize 32765 - to increase the line size of display. However only goes to 1102
set pagesize 50000 - to only have 1 set of title and '-' indicating the column size
I have tried with and without the ";" at the end of each line.
I perform the following to list the indexes
select * from dba_indexes
The Script Output display will list up to PARAMETERS and start truncating columns at GLOBAL_STATS.
Rows will be truncated for "GLOBAL_STATS"
However If I put another linesize following by the select. I will get my desired results 1 time. No columns dropped.
set linesize 32765
select * from dba_indexes
Any ideas?
Thanks
Frank