OraFAQ Forum: SQL & PL/SQL » How do I expand the number of characters to be displayed on one line?

Home » SQL & PL/SQL » SQL & PL/SQL » How do I expand the number of characters to be displayed on one line?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do I expand the number of characters to be displayed on one line? [message #227028]

Tue, 27 March 2007 03:03

stevefox777
Messages: 26
Registered: September 2006

Junior Member

How do I expand the number of characters to be displayed on one line?

Any help will be appreciated.

Steve

Report message to a moderator

Re: How do I expand the number of characters to be displayed on one line? [message #227030 is a reply to message #227028]

Tue, 27 March 2007 03:05

Maaher
Messages: 7065
Registered: December 2001

Senior Member

In SQL*Plus?

SQL> SET LINES[IZE] nnn (1 through 32767)

MHE

Report message to a moderator

Re: How do I expand the number of characters to be displayed on one line? [message #227033 is a reply to message #227030]

Tue, 27 March 2007 03:15

stevefox777
Messages: 26
Registered: September 2006

Junior Member

Maaher,
Thank you for your quick response!

It didn't work with the "[IZE]" option but it worked without it.
By the way what is the [IZE] for?

Cheers
Steve

Report message to a moderator

Re: How do I expand the number of characters to be displayed on one line? [message #227034 is a reply to message #227033]

Tue, 27 March 2007 03:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I was to indicate that you can write:

SET LINES
SET LINESI
SET LINESIZ
SET LINESIZE

Have you checked the SQL*Plus Guide and Reference?

EDIT: I did. And it is, in fact, like this:

SET LIN[ESIZE]

Ah well, never too old to learn Very Happy

MHE

[Updated on: Tue, 27 March 2007 03:20]

Report message to a moderator

Re: How do I expand the number of characters to be displayed on one line? [message #227045 is a reply to message #227028]

Tue, 27 March 2007 03:41

stevefox777
Messages: 26
Registered: September 2006

Junior Member

Thanx!

Report message to a moderator

Previous Topic:	Help with truncating minutes
Next Topic:	Select lower 5 and upper 5 records!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 06:10:37 CST 2024