| |
GeekInterview.com > Interview Questions > Oracle > Oracle Forms 4.0
| Print | |
Question: System _Generate Number
Answer: 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 |
| August 08, 2008 11:00:33 |
#1 |
| usmanahmad |
Member Since: August 2008 Total Comments: 1 |
RE: System _Generate Number
|
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 |
| |
Back To Question | |
