CODEWITHSUNDEEP
cmdsqlplus
Caffeinated
Caffeinated

Reputation: 12484

Is there any way to make the output in SQLPlus wider(on Windows )?

In an attempt to more easily view the output in SQLPlus, I fiddled with window-size properties and font(tiniest font).

But this is what I get :

enter image description here

It is exactly the same, just much less readable.

I just want to run the query :

select * from user_tables where rownum < 10 ;

Without the messy unreadable lines (currently I can't tell apart the data from table headings)

Upvotes: 1

Views: 1544

Answers (1)

peter.hrasko.sk
peter.hrasko.sk

Reputation: 4141

With the help of one useful SQL*Plus option and one additional helper option it is possible. Put

set linesize 32767
set trimout on

before your select.

Enjoy.

Upvotes: 2

Related Questions