Question: Using the Following table write a PL/SQL stored procedure that takes username as input and returns number of documents that user has permissions to view.

Using the Following table 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. Needs to be written in Oracle SQL. Using the Following table write a PL/SQL stored procedure that takes username

Document Policy Menu W2 Permissions UserName SYSTEM DOW USAM SYSTEM 20 W2 Form 1040 Policy DOW USAM JDOW SYSTEM leliey 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!

( 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...

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...

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...

In MySQL Create a table UserPermissions provide create and insert statements code. Next, write a PL/SQL stored procedure that takes username as input and returns number of documents that user has...

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...

2. 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...

C++ Programming, using namespace std and iostream. You were given two text files with comma separated values: books.txt, which is a list of books and their authors, and ratings.txt, which is a list...

I have finished this project. however, there are bugs. first. I don't know how to add reservations.txt and reservations_stats.txt in the project folder. Final Project Hotel Reservation System For...

"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...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Write a report on Amazon Fresh Company The organizational structure of the company and its governance. Ethics and Corporate Social Responsibility How the company formulate and implement strategy at...

Melissa Stewart a professional tennis player just received a bonus of 800000 for signing to sponsor an advertising campaign for a line of tennis products Her plan is to invest this payment in a fund...

The most an investor in a convertible preferred stock can lose is the value of the common stock into which the preferred stock may be converted

Analyze two types of protected classes under federal antidiscrimination statutes. Why are these liabilities for the company?

Employers usually do not have policies on using the telephone at work. Why, then, do employers need to develop policies on monitoring the use of email, the Internet, social media, and other forms of...

Do you think Anjana was correct in deciding to terminate Caleb when she did? Why or why not? Most organizations have policies and practices regarding absence from the workplace. These same...

Conduct your own Internet search, using any search engine, under the heading of employee discipline. Share with your classmates what you learned and provide at least 2 URLs you found helpful.