Valid 1Z0-146 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-146 Exam! ExamDiscuss.com now offer the newest 1Z0-146 exam dumps, the ExamDiscuss.com 1Z0-146 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-146 dumps with Test Engine here:
Access 1Z0-146 Dumps Premium Version
(136 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 14/47
Examine the PL/SQL code for the GET_TABLE_MD function given below:
CREATE OR REPLACE FUNCTION get_table_md RETURN CLOB IS
h NUMBER;
th NUMBER;
doc CLOB;
BEGIN
h := DBMS_METADATA.OPEN('TABLE');
DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR');
DBMS_METADATA.SET_FILTER(h,'NAME','TIMECARDS');
th := DBMS_METADATA.ADD_TRANSFORM(h,'DDL');
doc := DBMS_METADATA.FETCH_CLOB(h);
DBMS_METADATA.CLOSE(h);
RETURN doc;
END;
Which statement is true about the compilation and execution of the function?
CREATE OR REPLACE FUNCTION get_table_md RETURN CLOB IS
h NUMBER;
th NUMBER;
doc CLOB;
BEGIN
h := DBMS_METADATA.OPEN('TABLE');
DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR');
DBMS_METADATA.SET_FILTER(h,'NAME','TIMECARDS');
th := DBMS_METADATA.ADD_TRANSFORM(h,'DDL');
doc := DBMS_METADATA.FETCH_CLOB(h);
DBMS_METADATA.CLOSE(h);
RETURN doc;
END;
Which statement is true about the compilation and execution of the function?
