| VIEW [message #428261] |
Tue, 27 October 2009 11:17  |
ora2627
Messages: 1
Registered: October 2009
Location: Lahore
|
Junior Member |
|
|
Hi all
i am new to pl*sql, i am struggling to find solution for my problem,anybody please help me.
I Have two tables,Employee and Delivery
(i) Employee
It has colunms i.e. Name,Address and salary
(ii) Delivery
It has colunms i.e Pizza delivery,Destination
Requirement:
My requirement is that salary of the employee in Employee table will be updated only when it got a pizza delivery.
actually i am creating a VIEW, in view i want to grant permission to one of my user to update the salary of employee if it got the pizza delivery job, mind lets say i have 4 employees,so whoever employee will get the delivery, only that employee salary will be uploaded.
looking forward for kind help, if anyone could give me the querry for this.
Thanks & Regards
|
|
|
|
| Re: VIEW [message #428264 is a reply to message #428261] |
Tue, 27 October 2009 11:30  |
 |
Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ You have to be more precise on requirement and description of the table
2/ You have to show us what you tried, you don't do your homework but you can help you to do it when you are blocked
3/ You have to provide working Test case: create table and insert statements along with the result you want with these data.
4/ Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
