Home » SQL & PL/SQL » SQL & PL/SQL » printing on sam eline in a loop
printing on sam eline in a loop [message #248759] Sun, 01 July 2007 13:01 Go to next message
apuw
Messages: 13
Registered: June 2007
Junior Member
hi

how can print numbers on same line in following case .I dont want spaces in between ' '||i

for i In 1..10
loop
dbms_output.put_line(i);
end loop;


Thanks
Re: printing on sam eline in a loop [message #248760 is a reply to message #248759] Sun, 01 July 2007 13:08 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Please comply with the posting guidelines as specified in the #1 STICKY post at the top of this forum.

[Updated on: Sun, 01 July 2007 13:08] by Moderator

Report message to a moderator

Re: printing on sam eline in a loop [message #248762 is a reply to message #248759] Sun, 01 July 2007 13:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just read doc about dbms_output package.

Regards
Michel
icon9.gif  Re: printing on the same line from inside of a loop [message #248923 is a reply to message #248762] Mon, 02 July 2007 13:59 Go to previous messageGo to next message
apuw
Messages: 13
Registered: June 2007
Junior Member
I still couldnt find the function to print on same line when used inside a loop .

[Updated on: Mon, 02 July 2007 14:00]

Report message to a moderator

Re: printing on sam eline in a loop [message #248925 is a reply to message #248759] Mon, 02 July 2007 14:08 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
SQL> desc dbms_output

[Updated on: Mon, 02 July 2007 14:08] by Moderator

Report message to a moderator

Re: printing on the same line from inside of a loop [message #248926 is a reply to message #248923] Mon, 02 July 2007 14:09 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
List all the functions and post here what you understand they do.

Regards
Michel
Previous Topic: User alias
Next Topic: Unable to get a single row per result
Goto Forum:
  


Current Time: Sun Dec 04 20:30:49 CST 2016

Total time taken to generate the page: 0.05366 seconds