Home » SQL & PL/SQL » SQL & PL/SQL » VIEW
VIEW [message #428261] Tue, 27 October 2009 11:17 Go to next message
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 Go to previous message
Michel Cadot
Messages: 63802
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.

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


Current Time: Mon Sep 26 04:20:07 CDT 2016

Total time taken to generate the page: 0.05255 seconds