Home » RDBMS Server » Server Administration » format the output of dbms_output
format the output of dbms_output [message #372197] Thu, 18 January 2001 11:55 Go to next message
bwhale1
Messages: 4
Registered: January 2001
Junior Member
for ** in ** loop
dbms_output.put_line (v_1 ||v_2 );
could i make it to fixed-width format
end loop;

OR there are some other way to do it
thank you

Report message to a moderator

Re: format the output of dbms_output [message #372200 is a reply to message #372197] Thu, 18 January 2001 12:39 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Try this...

for i in c1 loop
dbms_output.put_line(rpad(i.col1,20,' ')||rpad(i.col2,20,' '));
end loop;

instead of 20 , you can specify length of each column..

Hope this helps
Suresh

Report message to a moderator

Previous Topic: How can I dop Index
Next Topic: Related primary/foreign keys
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 29 03:05:54 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.