What does the BFILENAME function do?

Examine this code
CREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2) IS
V_file BFILE;
v_filename VARCHAR2(16);
CURSOR emp_cursor IS
SELECT employee_id
FROM employees
WHERE Job_id = ‘IT_PROG’
FROM UPDATE
BEGIN
FOR emp_record IN emp_cursor LOOP
v_filename:=emp_record.emplyee_id||;GIF’;
V_file:=BFILENMAE(p_file_loc,v_filename);
END LOOP;
END;
/
What does the BFILENAME function do?

Examine this code
CREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2) IS
V_file BFILE;
v_filename VARCHAR2(16);
CURSOR emp_cursor IS
SELECT employee_id
FROM employees
WHERE Job_id = ‘IT_PROG’
FROM UPDATE
BEGIN
FOR emp_record IN emp_cursor LOOP
v_filename:=emp_record.emplyee_id||;GIF’;
V_file:=BFILENMAE(p_file_loc,v_filename);
END LOOP;
END;
/
What does the BFILENAME function do?

A.
It reads data from an external BFILE

B.
It checks for the existence of an external BFILE

C.
It returns a BFILE locator that is associated with a physical LOB binary file on the server’s file system

D.
It creates a directory object for use with the external BFILEs

Explanation:
In Oracle/PLSQL, the BFILENAME function returns a BFILE locator for a physical LOB binary file.
Incorrect Answers

A: DBMS_LOB.READ Procedure reads data from a BFILE. B: DBMS_LOB.FILEEXISTS functions checks for the existence of the file on the Server.
D: You do not use the BFILENAME function to create a directory object. The syntax to create the directory object is:
CREATE DIRECTORY<directory name> AS <operating system path>



Leave a Reply 0

Your email address will not be published. Required fields are marked *