Question
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
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.
| Document | UserName |
| Policy | SYSTEM |
| Menu | JDOW |
| W2 | USAM |
| Permissions | SYSTEM |
| W2 | JDOW |
| Form 1040 | USAM |
| Policy | JDOW |
| W2 | SYSTEM |
Provide screenshot of code running.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Systems Design Implementation And Management
Authors: Peter Rob, Carlos Coronel
6th International Edition
061921323X, 978-0619213237
