Whenever I perform select statements in the command line tool it doesn't use all of the space.
I've modified buffer size and window size and it just doesn't work.
Here is the screenshot: 
Add a comment
|
4 Answers
In sqlplus, execute this:
SET LINESIZE 1500
Comments
sqlplus does not automatically adjust its output width to fit your terminal window width. You need to change the width with something like set linesize 120
You might want to peruse the SQL*Plus documentation for more information on controlling output format.
Comments
Taken from the Oracle Forums:
If you want to make this permanent, in your DB/Oracle client directory look for the file glogin.sql in $ORACLE_HOME/sqlplus/admin and add this line:
SET LINESIZE 9999;
Now it will be set whenever you login into SQL Plus.
Comments
Setting your windows console properties alone won't help.
You need to tell oracle's sqlplus engine to put output in your perferred manner. This is done by Set options
example:
SET LIN 300
Will use 300 columns per line
