|
Using Oracle 8.1.7. I wanted to insert data from a table into another table. Table 1 has batch Id which is varchar2(10) and the sample data is \'0001234567\'. Table 2 has batch id which the type is number(10). So, when I insert the data, the data inserted become \'1234567\'. I used lpad(rec.batch_id,10,\'0\') but failed to append 0 in front of the data. Pls advise how can I insert \'0001234567\' into the table. Thanks in advance.
| Operating System : Microsoft Wndows XP
RAM : 512
|
