Can any one solve this [message #289603] |
Mon, 24 December 2007 04:36 |
balajiags
Messages: 10 Registered: July 2007
|
Junior Member |
|
|
I want to display the same output generated by following query
with the help of PL/SQL .
SELECT 1 , 2 ,3 ,4 ,5 FROM DUAL
UNION ALL
SELECT 16,17,18,19,6 FROM DUAL
UNION ALL
SELECT 15,24,25,20,7 FROM DUAL
UNION ALL
SELECT 14,23,22,21,8 FROM DUAL
UNION ALL
SELECT 13,12,11,10,9 FROM DUAL
|
|
|
|
Re: Can any one solve this [message #289610 is a reply to message #289604] |
Mon, 24 December 2007 05:11 |
balajiags
Messages: 10 Registered: July 2007
|
Junior Member |
|
|
This is my previousprogram answer.I get the result what i want.
declare
n number :=5;
m number :=11;
a number;
begin
for x in 1..M loop
dbms_output.put_LINE(' ');
for y in 1..m loop
a:=x*y;
dbms_output.put(LPAD(a,4));
exit when a= x*10;
end loop;
end loop;
end;
|
|
|
|
Re: Can any one solve this [message #289612 is a reply to message #289611] |
Mon, 24 December 2007 05:24 |
balajiags
Messages: 10 Registered: July 2007
|
Junior Member |
|
|
That is my previous question for output like below.
1 2 3 4 5 6 7 8 9 10
2 4 6 8 10 12 14 16 18 20
3 6 9 12 15 18 21 24 27 30
4 8 12 16 20 24 28 32 36 40
5 10 15 20 25 30 35 40 45 50
6 12 18 24 30 36 42 48 54 60
7 14 21 28 35 42 49 56 63 70
8 16 24 32 40 48 56 64 72 80
9 18 27 36 45 54 63 72 81 90
10 20 30 40 50 60 70 80 90 100
and this time i want o/p for the below query by PL/SQL.
SELECT 1 , 2 ,3 ,4 ,5 FROM DUAL
UNION ALL
SELECT 16,17,18,19,6 FROM DUAL
UNION ALL
SELECT 15,24,25,20,7 FROM DUAL
UNION ALL
SELECT 14,23,22,21,8 FROM DUAL
UNION ALL
SELECT 13,12,11,10,9 FROM DUAL
|
|
|
|
|
|
|
|
|
|
|
|