| oracle 8i [message #86866] |
Mon, 15 November 2004 21:54  |
shish mate
Messages: 49
Registered: February 2004
|
Member |
|
|
i want to upadate field in my table affter some specific time.
e.g in emp table at current date emp is having salary of rs.50000 but in next month his sal should be automaticaly increment by 1000.
is it possibal.
urgent
thanks
ASHish
|
|
|
|
| Re: oracle 8i [message #86882 is a reply to message #86866] |
Tue, 16 November 2004 22:47  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Yes this is possible.
All you need to do is to write a stored Procedure & schedule it to run at Perticular date/time using DBMS_JOBS.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
