Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Applications)Module HRMSeg - 000001,000002.Pls update on thisRegardsVenu

  • Interview Candidate
  • 1
  • 4068

Showing Answers 1 - 1 of 1 Answers

Mano

  • Sep 26th, 2006
 

Hi,

select max(nvl(empno,000000))+1 from emp

U have to wrie this in pre_text_item trigger of the empno item.

Check and confirm.

Thanks and bye

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions