Introduction to set serveroutput on in Oracle, oracleserveroutput

Introduction to set serveroutput on in Oracle, oracleserveroutput
Definition

Set serveroutpu on enables oracle to use its own output method
Dbms_output.put_line ('xx ');

Scope of use

Used in PL/SQL command window and SQL PLUS

Permanently valid

To avoid entering set serveroutput on every time, you can check the glogin. SQL file in the Oracle installation directory and add set serveroutput on to the file.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.