Sql*plus Output

[clinton]

How do I increase the width of a page in sqlplus?
Example, if I issues select * from dba_tables, I would like to
see most (if not all) the output on one line.

Is there a set command that can be used to achive this?

[stecal]

show lines
set lines xxx
set linesize xxx

set page xxx
set pagesize xxx

where xxx = a number. wide page? try around 110 to 130
vertical length? try around 45-60

set wrap off/on

Oracle SQL*PLus, The Definitive Guide, O'Reilly. Buy it. Read it.

SQL*Plus window on Windows - change environment setting is another way (Options>Environment)

[roman33]

You can also set the width and length for the particular SQL*PLUS environment by clicking on options tab on top of the sqlplus page: i.e

Options-->Environment-->scoll down to linesize;
click on linesize-->custom=100
scoll down to pagesize-->custom=24
click OK

reenter your select statement.

You can play with these values to suit your needs.


Roman33
OCP 8,8i,9i

[stecal]

Originally posted by roman33
You can also set the width and length for the particular SQL*PLUS environment by clicking on options tab on top of the sqlplus page: i.e

Options-->Environment

Did I not just say that in the previous post? FYI, Options is not a "tab" on the window, it is a menu-driven item.

[roman33]

You're right stecal, I missed your response line.