Monday, October 5, 2015

dbms_output.put_line

Dear readers, here is an example for show how to use dbms_output package for printing text message

set serveroutput on

DECLARE
 buffer VARCHAR2(100);
 status INTEGER;
BEGIN
  dbms_output.put_line('This is');
  dbms_output.put_line('a test.');
  dbms_output.get_line(buffer, status);
  dbms_output.put_line('Buffer: ' || buffer);
  dbms_output.put_line('Status: ' || TO_CHAR(status));
END;
/


Yasser

No comments:

Post a Comment