OraFAQ Forum: Server Administration » printing on same line

Home » RDBMS Server » Server Administration » printing on same line

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

printing on same line [message #371775]

Mon, 04 December 2000 14:17

kusuma
Messages: 5
Registered: December 2000
Location: India

Junior Member

Hi,

Can anybody suggest how to print in the same line.
ie i have a table emp and dep. I would like to
print emp name under each dep table
ie
dep emp name
---- --------
cs john
rick
sam

hr sam2
jim
eg.

Report message to a moderator

Re: printing on same line [message #371791 is a reply to message #371775]

Wed, 06 December 2000 13:43

Madhav Kasojjala
Messages: 42
Registered: November 2000

Member

Hi,
If it is through SQLPLUS,
type the command
set break on deptno
and then run the SQL u will get the output.
If this is not what u r looking for lemme know

Report message to a moderator

Re: printing on same line [message #371797 is a reply to message #371775]

Thu, 07 December 2000 04:48

vasanth Kumar
Messages: 3
Registered: December 2000

Junior Member

You can even try at SQL Prompt to adjust line width:
Set linesize 120

Try different values to suit your display

Report message to a moderator

Previous Topic:	Record block
Next Topic:	Dynamic SQL and Ref Cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 06:11:11 CDT 2024