For Loop coding problem [message #298206] |
Tue, 05 February 2008 05:57  |
adilsami
Messages: 46 Registered: October 2007
|
Member |
|
|
Can any one guide me with this code
it doesn't show any result .
declare
v_table number(4) := &table;
v_low number(4) :=&Low;
v_hi number(4) :=&Hi;
begin
for i in v_low..v_hi
loop
dbms_output.put_line (v_table * i ||' = '|| v_table * i);
end loop;
end;
/
|
|
|
|
|
Re: For Loop coding problem [message #298217 is a reply to message #298206] |
Tue, 05 February 2008 06:30   |
adilsami
Messages: 46 Registered: October 2007
|
Member |
|
|
i want to display the Table Number instead
the variable name..
declare
v_table number(4) := &table;
v_low number(4) :=&Low;
v_hi number(4) :=&Hi;
begin
for i in v_low..v_hi
loop
dbms_output.put_line ('v_table * ' ||i||' = '||v_table*i);
end loop;
end;
/
The OutPut :
v_table * 1 = 1
v_table * 2 = 2
v_table * 3 = 3
v_table * 4 = 4
|
|
|
|