doubt in loop [message #83266] |
Sun, 31 August 2003 01:30 |
moon
Messages: 7 Registered: July 2002
|
Junior Member |
|
|
I want to insert 20 records with the value incremented by one.
Declare
i varchar2(8) := '00000002';
a varchar2(8);
Begin
for j in 1..19 loop
i := i + 1;
message(i);pause;
End loop;
End;
In the above code i am getting the incremented value but i am getting only the numbers. But i am in need of with zeros concated..as the item is a varchar2 and not a number field..can any one suggest me..
for ex i am getting 3 instead of '00000003'.
|
|
|
|
|