Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

displaying more than 80 characters with sqlplus

679223Mar 2 2009 — edited Mar 2 2009
I wonder if there is a way to display more than 80 characters with sqlplus. I thought that if I enlarge the console script the
the sqlplus would adjust the wrapping with the relation to the width of the screen but it did not. For example, below I ran a sql query and it is very difficult to see what data goes with what field. I wonder if there is way to force sqlplus to adjust to new width of the console to display all the fields at the same time, for example? Thank you.

SQL> select * from FLT_SCHEDULE;

FLT# AIRLINE DTIME FRO ATIME TO_ MILES
----- ------------------------- ---------- --- ---------- --- ----------
PRICE
----------
DL242 Delta 01/01/1970 ATL 01/01/1970 BOS


SK912 SAS 01/01/1970 CPH 01/01/1970 JFK


AA242 AA 01/01/1970 CHI 01/01/1970 BOS
This post has been answered by Florian W. on Mar 2 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2009
Added on Mar 2 2009
5 comments
4,073 views