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

usmanahmad

 Profile Answers by usmanahmad Questions 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 ...

Answer Question  Select Best Answer