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
Get step-by-step solutions from verified subject matter experts
