CODEWITHSUNDEEP
oracle-databasecmdlinesqlplus
anon
anon

Reputation:

Oracle SQL CMD Line

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: alt text

Upvotes: 3

Views: 809

Answers (4)

glenneroo
glenneroo

Reputation: 2054

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.

Upvotes: 1

David Gelhar
David Gelhar

Reputation: 27900

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.

Upvotes: 1

ring bearer
ring bearer

Reputation: 20783

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

Upvotes: 0

DVK
DVK

Reputation: 129403

In sqlplus, execute this:

SET LINESIZE 1500

Upvotes: 5

Related Questions