In this blog, we’ll discuss the DBMS Output in PL/SQL. The DBMS_OUTPUT may be a built-in package that permits you to display output, debugging information, and send messages from PL/SQL blocks, subprograms, packages, and triggers. we’ve already used this package throughout our blog.
Let us check out alittle code snippet which will display all the user tables within the database. Try it in your database to list down all the table names −

BEGIN 
dbms_output.put_line (user || ' Tables within the database:'); 
FOR t IN (SELECT table_name FROM user_tables) 
LOOP 
dbms_output.put_line(t.table_name); 
END LOOP; 
END; 
/

DBMS_OUTPUT Subprograms
The DBMS_OUTPUT package has the subsequent subprograms –

S.No	Subprogram & Purpose
1	DBMS_OUTPUT.DISABLE; Disables message output.
2	DBMS_OUTPUT.ENABLE(buffer_size IN INTEGER DEFAULT 20000); Enables message output. A NULL value of buffer_size represents unlimited buffer size.
3	DBMS_OUTPUT.GET_LINE (line OUT VARCHAR2, status OUT INTEGER); Retrieves a one line of buffered information.
4	DBMS_OUTPUT.GET_LINES (lines OUT CHARARR, numlines IN OUT INTEGER); Retrieves an array of lines from the buffer.
5	DBMS_OUTPUT.NEW_LINE; Puts an end-of-line marker.
6	DBMS_OUTPUT.PUT(item IN VARCHAR2); Places a partial line in the buffer.
7	DBMS_OUTPUT.PUT_LINE(item IN VARCHAR2); Places a line in the buffer.

Example

DECLARE 
lines dbms_output.chararr; 
num_lines number; 
BEGIN 
-- enable the buffer with default size 20000 
dbms_output.enable; 

dbms_output.put_line('Hello Reader!'); 
dbms_output.put_line('Hope you've got enjoyed the tutorials!'); 
dbms_output.put_line('Have an excellent time exploring pl/sql!'); 

num_lines := 3; 

dbms_output.get_lines(lines, num_lines); 

FOR i IN 1..num_lines LOOP 
dbms_output.put_line(lines(i)); 
END LOOP; 
END; 
/

When the above code is executed at the SQL prompt, it produces the subsequent result −
Hello Reader!
Hope you’ve got enjoyed the tutorials!
Have an excellent time exploring pl/sql!

PL/SQL procedure successfully completed.
So, this brings us to the end of blog. This Tecklearn ‘DBMS Output in PL-SQL’ blog helps you with commonly asked questions if you are looking out for a job in Oracle Pl-SQL. If you wish to learn Oracle PL-SQL and build a career in Database domain, then check out our interactive, Oracle PL-SQL Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Oracle PL SQL Training

Oracle PL-SQL Training

About the Course

Oracle PL/SQL online training course provides you the complete skills needed to create, implement and manage robust database applications using the Oracle Database tools. Our expert instructors will help you to master PL SQL advanced features, from performance to maintainability to the application code architecture. Our best online classes will help you to gain a precise knowledge of PL SQL language, architecture, interactions with the SQL engine, data types, and much more. The entire training is in line with the Oracle PL/SQL certification.

Why Should you take Oracle PL-SQL Training?

• The Average salary of a Senior Oracle PL-SQL Developer is $131,878 per annum – ZipRecuiter.com
• PL-SQL has a market share of 23% globally.
• IBM, TCS, Tech Mahindra, Oracle, Wipro & other MNCs worldwide use Pl-SQL for their database deployments.

What you will Learn in this Course?

Introduction to Oracle SQL
• Database Models
• RDBMS
• Components of SQL
• DataTypes
• DDL-Create, Alter, Rename, Drop, Truncate
Manipulating Data using SQL
• Constraints –Unique, Not Null, Primary Key, Check Constraint, Foreign Key
• DML Commands-Insert, Update, Delete
• Order by Clause
• Group Functions
• SET Operators- Union All, Union, Intersect, Minus
• TCL Commands-Commit, RollBack, Savepoint
Oracle Views and Synonyms
• Types of Views
• Synonyms
• Types of Synonyms
• Indexes
• Types of Indexes
Using Subqueries to Solve Queries
• Subqueries
• Co-Related Subquery
OLAP Functions
• OLAP Features
• Roll Up
• Model Clause
• Dimension Modelling
Conditional Statement
• Block
• Variable Attributes
• Nested Blocks
• Conditional Control Statements
• Iterative Controls (Loop)
Cursor Management
• Types of Cursor
• Writing Explicit cursors
• Explicit cursor functions
• Advance Explicit cursor
• Cursor with parameters
Exception Handling
• Handling Exception
• Handling Exception with PL/SQL Predefined Exceptions,
• User Defined Exceptions
• Non-Predefined Error
• Function for trapping Exception
• Trapping user-defined Exception
Subprogram, Procedure and passing parameters and Advance Package Concepts and functions
• Important Features of Sub-Programs
• Procedure
• Functions
Trigger Management
• Introduction to Triggers
• Types of Triggers
• Compound Triggers
Oracle Job Scheduling
Large Object Functions
• Large object functions – BFILENAME, EMPTY_BLOB, EMPTY_CLOB etc
Important Features of Oracle
Advance level- Scripting

455