Oracle SQL CMD Line

Question

Whenever I execute select statements in a command line tool, it does not use all the space.

I changed the buffer size and window size and it just doesn't work.

Here is a screenshot:

Answer 1

In sqlplus do the following:

SET LINESIZE 1500 

Answer 2

sqlplus does not automatically adjust its output width so that it matches the width of the terminal window. You need to change the width withset linesize 120

You can consult the SQL * Plus documentation for more information on controlling the output format.

Answer 3

Oracle:

, DB/Oracle glogin.sql $ORACLE_HOME/sqlplus/admin

SET LINESIZE 9999;

SQL Plus.

Answer 4

Setting Windows console properties will not help. You must tell the oracle sqlplus engine to output the output in your perferred manner. This is done using Setoptions.

Example:

SET LIN 300

Will use 300 columns per row