Question: Answer the following questions: 1- Write SQL code to list all employees who are working more than 17 years.(2 Marks 2 Write SQL code to

Answer the following questions: 1- Write SQL code to list all employees who are working more than 17 years.(2 Marks 2 Write SQL code to list all assignments of employee whose first name start with the (3 Marks) 3 Write SQL code to list the job description for all employees who have assignments letter "A" belong to a project that its name is "Evergreen" . 4 Write PL/SQL procedure that accept the employee first name then the procedure display the number of his/her assignments. (4 Marks) (6 Marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!