Re: HELP! PL/SQL-LEADING ZERO

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Sun, 5 Nov 2000 10:29:51 +0900
Message-ID: <vM2N5.44$C33.618@news.hananet.net>

hi.
If the type of runno is number then you cannot insert values like 0001. 0001 is only output format. Use to_char()

"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 - 19:29:51 CST