a) For producing outputs on the video device we need the assistance of DBMS_OUTPUT package.
b) The package enables to display output from PL/SQL blocks and subprogram.
c) The procedure PUT_LINE outputs information to a buffer in the SGA.
d) The information can be displayed by calling the procedure GET_LINE or by setting SERVEROUTPUT ON in SQL*PLUS.
Syntax:
DBMS_OUTPUT.PUT_LINE('Manage');
e) Has limitation for maximum off 255 character per line.
f) The DBMS_OUTPUT package is owned by the Oracle USER SYS.
g) It writes information to the BUFFER for STORAGE.
h) The size of the BUFFER can be set between 2000 to 1,000,000 Bytes.
i) The specifications to SET Buffers are
a) SET SERVEROUTPUT ON;
b) SET SERVEROUTPUT ON SIZE 5000;
c) SET SERVEROUTPUT OFF;
[7:45 PM
|
0
comments
]



0 comments
Post a Comment
Do comment to make this blog better