Oracle SQL CMD Line

Question

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:

Answer 1

In sqlplus, execute this:

SET LINESIZE 1500 

Answer 2

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

Answer 3

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.