VIEW [message #428261] Tue, 27 October 2009 11:17 Go to next message
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

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 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: Calling Linux Command Using Pl/SQL
Next Topic: Unique constraint error
Goto Forum:

Current Time: Wed Oct 26 22:43:04 CDT 2016

Total time taken to generate the page: 0.06557 seconds