10A.56
A. In the Oracle SQL Developer folder structure in your My Documents folder, create a folder named DBP-e12-VRG-CH10A-PQ-Database. Use this folder to save and store *.sql scripts containing the SQL statements that you are asked to create in the remaining questions in this section.
B. Using the examples in this chapter as a template, use the Oracle Enterprise Manager to create a tablespace named VRGCH10APQ, a user named VRG_CH10A_PQ_USER with a password of VRG_CH10A_PQ_USER+password, and a role named VRGCH10APQ_DEV that has the CREATE VIEW system privilege. Assign VRG_CH10A_PQ_USER the CONNECT, RESOURCE, and VRGCH10APQ_DEV roles.
C. Create the tables in Figure 10A-28, but do not create the NationalityValues constraint.
D. Fill your database with data as shown in the chapter in Figure 10A-38.
E. Write a stored procedure to read the ARTIST table and display the artist data using the DBMS_OUTPUT.PUT_LINE command.
F. Write a stored procedure to read the ARTIST and WORK tables. Your procedure should display an artist, then display all the works for that artist, then display the next artist, and so forth. Accept the name of the artist to display as an input parameter