In Oracle SQL :

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.

Please use this table:

---------------------------------------------------------------------

CREATE TABLE UserPermissions ( Document varchar(20) NOT NULL, UserName varchar(20) NOT NULL);

INSERT INTO userpermissions (Document,UserName) VALUES ('Policy','SYSTEM');

INSERT INTO userpermissions (Document, UserName) VALUES ('Permissions','SYSTEM');

INSERT INTO userpermissions (Document, UserName) VALUES ('W2','SYSTEM');

INSERT INTO userpermissions (Document, UserName) VALUES ('Policy','JDOW');

INSERT INTO userpermissions (Document, UserName) VALUES ('Menu','JDOW');

INSERT INTO userpermissions (Document, UserName) VALUES ('W2','JDOW');

INSERT INTO userpermissions (Document, UserName) VALUES ('Form 1040','USASM');

INSERT INTO userpermissions (Document, UserName) VALUES ('W2','USASM');