Home » SQL & PL/SQL » SQL & PL/SQL » How do I expand the number of characters to be displayed on one line?
How do I expand the number of characters to be displayed on one line? [message #227028] Tue, 27 March 2007 03:03 Go to next message
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
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 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
In SQL*Plus?
SQL> SET LINES[IZE] nnn (1 through 32767)


MHE
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Laughing I was to indicate that you can write:
SET LINES
SET LINESI
SET LINESIZ
SET LINESIZE


Idea 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 Go to previous message
stevefox777
Messages: 26
Registered: September 2006
Junior Member
Thanx!
Previous Topic: Help with truncating minutes
Next Topic: Select lower 5 and upper 5 records!!
Goto Forum:
  


Current Time: Sat Dec 10 05:10:06 CST 2016

Total time taken to generate the page: 0.21805 seconds