Multiple choice

Which of the following DBMS_OUTPUT subprograms retrieves an array of lines from the buffer?

  1. DBMS_OUTPUT.GET_LINE (line OUT VARCHAR2, status OUT INTEGER);

  2. DBMS_OUTPUT.GET_LINES (lines OUT CHARARR, numlines IN OUT INTEGER);

  3. DBMS_OUTPUT.PUT(item IN VARCHAR2);

  4. DBMS_OUTPUT.PUT_LINE(item IN VARCHAR2);

  5. DBMS_OUTPUT.DISABLE;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

It retrieves an array of lines from the buffer.

Keep practicing — related questions