Home » Developer & Programmer » Forms » Generating unique numbers
Generating unique numbers [message #150595] Thu, 08 December 2005 10:58 Go to next message
vinodkumarn
Messages: 60
Registered: March 2005
Member
Hi all,

I have a situation where in i have to assign nos to one of the column from forms like S01,S02,S03......S10,S11.....S100,S101........ and so on whenever user creates a record.

can anyone help how to generate these nos from forms. i do not have sequences for that column.

Thanks
Vinod

Report message to a moderator

Re: Generating unique numbers [message #150659 is a reply to message #150595] Thu, 08 December 2005 23:42 Go to previous message
m_Usuf
Messages: 21
Registered: November 2005
Location: Karachi Pakistan
Junior Member
vinodkumarn wrote on Thu, 08 December 2005 21:58

Hi all,

I have a situation where in i have to assign nos to one of the column from forms like S01,S02,S03......S10,S11.....S100,S101........ and so on whenever user creates a record.

can anyone help how to generate these nos from forms. i do not have sequences for that column.

Thanks
Vinod


GoodDay!

Hey the following codes will be helpfull you.

DECLARE
MSERIES NUMBER(5);
BEGIN
SELECT
NVL(MAX(SUBSTR(SERIES,3,5)),0)) + 1 INTO MSERIES FROM MY_SERIES;
:MY_SERIES.SERIES:= 'S-' || LPAD(MSERIES,3,0);
END;

Thanks

Yousuf

Report message to a moderator

Previous Topic: Elements in Lists
Next Topic: Logout... can anyone help please...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:28:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.