| UNIQIUE NUMBER [message #324267] |
Sun, 01 June 2008 04:50  |
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
|
Senior Member |
|
|
Hi Guyz,
hope everyone is fine. after a long time i visit this valuable website.
anyhow guyz i have a query if anyone can give me suitable reply to solve my problem.
I have the below table
PAYROLL_ID NUMBER(10)unique,
PAYROLL_DATE DATE (primary key)
at the end of the month im process the payroll
in the PAYROLL_ID i wanna to enter single unique number to all employees.
suppose if i enter --> 10001001 this number at the end of the month or while processing payroll it will save to all employee payroll how can i do this?
and in next month it will show next record 10001002. any valuable solution please?
Regards
|
|
|
|
| Re: UNIQIUE NUMBER [message #324289 is a reply to message #324267] |
Sun, 01 June 2008 09:51  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I'm not sure I understood what you've said, but it looks like a simple UPDATE statement:UPDATE your_table SET
payroll_id = 10001001; UPDATE your_table SET
payroll_id = :block_name.item_name;
If you don't enter a value manually, a sequence might be a good choice to obtain a| Quote: | single unique number
|
If you have to do that at the end of the month and if payroll_id value doesn't depend on user input, you might schedule this operation as a job using DBMS_JOB or DBMS_SCHEDULER packages.
If nothing of above mentioned "solutions" meets your requirements, I'm afraid I misunderstood the question.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
