OraFAQ Forum: Server Administration » Does each line only display one column ?

Home » RDBMS Server » Server Administration » Does each line only display one column ?

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

Does each line only display one column ? [message #371520]

Wed, 01 November 2000 20:34

Angus
Messages: 18
Registered: October 2000

Junior Member

Anyone could tell me how to display the column that occupied a whole line?
form example :
select empno, ename from emp;

expected result should be:
1111
name one
1112
name two
....
Any suggestions? Thanks

Report message to a moderator

Re: Does each line only display one column ? [message #371521 is a reply to message #371520]

Wed, 01 November 2000 20:48

Cliff
Messages: 6
Registered: October 2000

Junior Member

You can write:
"set linesize 15"
The number can be changed according the needs.

Report message to a moderator

Re: Does each line only display one column ? [message #371523 is a reply to message #371521]

Thu, 02 November 2000 01:58

Angus
Messages: 18
Registered: October 2000

Junior Member

however, if the the length of columns is quite different. I think the sate linesize will not work. Any other suggestions?

Report message to a moderator

Re: Does each line only display one column ? [message #371527 is a reply to message #371523]

Thu, 02 November 2000 12:05

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

in SQL*Plus

set linesize 80;
column empno format a80;

select to_char(empno), ename from emp;

or (using the max numeric format)

column empno format 99999999999999999999999999999999999999999999999999999999999999999
select empno, ename from emp;

Report message to a moderator

Previous Topic:	Oracle script needed immediately
Next Topic:	Columns not displayed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 19:29:52 CDT 2024