Question: ( SQL Developer) Create a table UserPermissions (provide create and insert statements code) (5 points for the correct code of the procedure and 3 points
( SQL Developer) Create a table UserPermissions (provide create and insert statements code) (5 points for the correct code of the procedure and 3 points for testing your function; one point per test case). Do not modify table or column names.
| Document | UserName |
| Policy | SYSTEM |
| Menu | JDOW |
| W2 | USAM |
| Permissions | SYSTEM |
| W2 | JDOW |
| Form 1040 | USAM |
| Policy | JDOW |
| W2 | SYSTEM |
Write a PL/SQL stored procedure that takes username as input and returns number of documents that user has permissions to view. If username is not in the table, your procedure should return: "no documents for USERNAME".
Include code that can be copied and ran, and screenshots of the results. Do not forget to test "user not found" case.
Sample output: set serveroutput on: exec p vies ('PAUL' exec p vieus('SYSTE: Script Output x > Query Result x 4 Task completed in 0.02 seconds PROCEDURE P VIEWS compiled anonymous block completed no documents for PAUL anonymous block completed three documents) for SYSTEH
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
