Question
Can someone please help with creating the stored procedure and execution code for this ?(oracle pl/sql) Create a table UserPermissions (provide create and insert statements
"Can someone please help with creating the stored procedure and execution code for this ?(oracle pl/sql)
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".
The number of documents has to be displayed as a word instead of using digits. To convert number to words read http://viralpatel.net/blogs/convert-number-into-words-oracle-sql-query/
Include code that can be copied and ran, and screenshots of the results. Do not forget to test "user not found" case.
Sample output:
Sample output:
set serveroutput on exec p_views( 'PAUL') exec p_views('SYSTEN'] Query Resultx Task completed in 0.02 seconds PROCEDURE P_VIEUs compiled anonymous block completed no documents for PAUL anonymous block completed three YSTEM document(s) for SStep 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