Re: HELP! PL/SQL-LEADING ZERO

From: Eric Givler <egivler_at_flash.net>
Date: Sun, 05 Nov 2000 02:10:27 GMT
Message-ID: <nk3N5.5668$pq3.426243@news.flash.net>

make runno varchar2(4)
then insert into test (runno) values ( lpad(i,4,'0') )

"Ho" <kowho_at_singnet.com.sg> wrote in message news:8u266p$bo2$1_at_coco.singnet.com.sg...
> I need to create a table with 1000 records. I issue the INSERT command
> within a loop.
>
> INSERT INTO TEST (RUNNO) VALUES(I)
>
> After running the SQL, the records are:
>
> 1
> 2
> 3.....
>
> What I want is :
>
> 0001
> 0002
> .
> .
> .
> 0999
> 1000
>
> How to achieve this ?
>
> Many thanks for your help in advance.
>
>
>
Received on Sat Nov 04 2000 - 20:10:27 CST