For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
hi how can I display the number with the leading zero
for example the number in database is 10999222 and display it as 010999222
I use lpad(empno,1,0) is displaying 1 am I database 11g