Need the output display in Horizontal format in SQL/PLUS Workshee t in Oracle.

You could try :

set linesize 1000
set trimspool on

That way each line will be 1000 characters wide, and this should stop the wrapping.
The trimspool bit simply means that if you spool the output to a file, SQLPlus will not space fill every line to 3000 characters wide.

Another option is

set wrap off which stops lines wrapping, but simply truncates output at the 'linesize' column.

HTH regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------