Home » Developer & Programmer » Forms » Start auto numbering with 01
Start auto numbering with 01 [message #635657] Sun, 05 April 2015 05:50 Go to next message
manisngpl
Messages: 42
Registered: December 2014
Location: Faisalabad, Pakistan
Member

Hello Members,

I would like to start auto numbering with 01 not with 1 in when validate trigger.

I'm using the following query that results 1, 2, 3....n

select nvl(max(col_n),0)+1 into :Field_name from Table_name;

but I would like to get following results

01, 02, 03...09....10..11..12..13 etc.

Please help me in the matter.

Regards,

Muhammad Usman
Re: Start auto numbering with 01 [message #635658 is a reply to message #635657] Sun, 05 April 2015 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
  1* SELECT TO_CHAR(1,'09') NUM FROM DUAL
SQL> /

NUM
---
 01

Re: Start auto numbering with 01 [message #635666 is a reply to message #635658] Sun, 05 April 2015 22:18 Go to previous message
manisngpl
Messages: 42
Registered: December 2014
Location: Faisalabad, Pakistan
Member

Thank You Dear BlackSwan, It's working
Previous Topic: get the window current
Next Topic: FRM-40733 pl/sql built-in SET_GROUP_CHAR_CELL failed
Goto Forum:
  


Current Time: Mon Aug 03 07:46:51 CDT 2020