OraFAQ Forum: Forms » Start auto numbering with 01

Home » Developer & Programmer » Forms » Start auto numbering with 01

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Start auto numbering with 01 [message #635657]

Sun, 05 April 2015 05:50

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

Report message to a moderator

Re: Start auto numbering with 01 [message #635658 is a reply to message #635657]

Sun, 05 April 2015 08:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

  1* SELECT TO_CHAR(1,'09') NUM FROM DUAL
SQL> /

NUM
---
 01

Report message to a moderator

Re: Start auto numbering with 01 [message #635666 is a reply to message #635658]

Sun, 05 April 2015 22:18

manisngpl
Messages: 42
Registered: December 2014
Location: Faisalabad, Pakistan

Member

Thank You Dear BlackSwan, It's working

Report message to a moderator

Previous Topic:	get the window current
Next Topic:	FRM-40733 pl/sql built-in SET_GROUP_CHAR_CELL failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 19:06:31 CDT 2024