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".The number of documents has to be displayed as a word instead of using digits. The table name should be USERPERMISSIONS

Here is the Table below:

Write a PL/SQL stored procedure that takes username as input and returns

Document Palbey Menu UserName SYSTEM JDOW USAM SYSTEM Permissions 20 W2 Form 1040 Policy JDOW USAM JDOW SYSTEM W2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!