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
![]() |
![]() |