| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> i want to print in single line pl/sql block
how can i get output like this
1 = 1
1+2 = 3
1+2+3 = 6
........
1+2+3+4+5+6+7+8+9+10 = 55;
i have to print same order.
i don't got it but i wrote something see and modify and send reply
---
declare
v number := 0;
v1 number;
begin
for i in 1..10 loop
for j in 1..i loop
v:= v+j;
dbms_output.put_line(j);
if j<>i then
dbms_output.put_line(' + ');
end if;
end loop;
dbms_output.put_line(' = '||v);
v:=0;
end loop;
end;
/
Received on Tue Aug 28 2007 - 05:18:56 CDT
![]() |
![]() |