Chapter 23. DBMS_OUTPUT Built-in Package

This chapter tests your understanding of DBMS_OUTPUT, the built-in package that allows you to display messages to your session’s standard output device.

Beginner

23-1.

Before developers had DBMS_OUTPUT, how did they obtain information about the activity that had taken place inside their code?

23-2.

DBMS_OUTPUT has a buffer or memory area defined inside the package that holds the data you want displayed until the time comes to “flush” it to the screen. What is the maximum size of the buffer for any single PL/SQL block execution? What are the different types of information you can put in the buffer?

23-3.

Write a “Hello World” procedure that puts into the DBMS_OUTPUT buffer (and eventually displays on the screen) the string “hello world” followed by a newline character.

23-4.

How do you enable output from the DBMS_OUTPUT package?

23-5.

How do you enable DBMS_OUTPUT in your SQL*Plus session?

23-6.

How can you flush the DBMS_OUTPUT buffer and turn off output from this package?

23-7.

What is the default size of the DBMS_OUTPUT buffer in SQL*Plus?

23-8.

How do you minimize the chance of hitting the buffer overflow error when working with DBMS_OUTPUT in SQL*Plus?

23-9.

Write a procedure to display the current date and time on two different lines.

23-10.

Write a procedure to display the last_name and salary of each person in the employee table.

Intermediate

23-11.

Explain the output displayed in the following session in SQL*Plus:

SQL> SET SERVEROUTPUT ON SQL> EXEC DBMS_OUTPUT.PUT_LINE ...

Get Oracle PL/SQL Programming: A Developer's Workbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.