System _Generate Number

How can you generate the system _generate number in forms automatically
hint: IN FORMS WE CREATING ONE DATA BLOCK BUT ONE CLOUMN (EMPLOYEE_ID) THIS COLUMN GENERATE THE ID NUMBER AUTOMATICALLY WITH OUT CREATING SEQUNENCE

akbuhari
Profile Answers by akbuhari Questions by akbuhari
Jul 7th, 2008
1
2334

Questions by akbuhari

Oracle Forms 4.0

Answer

Showing Answers 1 - 1 of 1 Answers

usmanahmad
Profile Answers by usmanahmad

Aug 18th, 2008

1: EMPLOYEE_ID := DBMS_RANDOM.STRING('X',6); ---- its generates unique EMPLOYEE_ID six char long

2: Then check whether newly generated id is already in DB. Create a cursor which select and return ids and the match both vales. If both are equal then go back to step 1

3: you unique value has created.

I hope this will help you.

Usman