Question: Create a view to display the employee id, employee first name, surname and invoice date for a donation that occurred on 18 May 2022.
Create a view to display the employee id, employee first name, surname and invoice date for a donation that occurred on 18 May 2022. Sample Output: EMPLOYEE_ID emp103 FIRST NAME Adanya SURNAME Andrews INVOICE_DATE 18-MAY-22 explain what a View in Oracle is, and any two benefits gained by CHARITY 4 AFRICA for using the View you created in Provide this information as a comment at the end of code. Create a PL/SQL query to display the combined customer name, donation purchased, donation price and the reason that the donation was returned.
Step by Step Solution
3.44 Rating (147 Votes )
There are 3 Steps involved in it
To create a view in Oracle that displays the employee id first name surname and invoice date for a d... View full answer
Get step-by-step solutions from verified subject matter experts
