/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder.
Examine the following commands that are executed by the DBA:
SQL>CREATE DIRECTION my_dir AS /temp/my_files:
SQL>GRANT READ ON DIRECTORY my_dir To public:
View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.
SCOTT executes the procedure as follows:
SQL>SET SERVEROUTPUT ON -
SQL>EXEC read_file (MY_DIR, FACULTYLIST.TXT)
What is the outcome?
Aditya
2 years, 9 months agoabdullah_barham
1 year, 10 months agoabdullah_barham
1 year, 10 months ago