Thursday, April 24, 2014

HA...... HA........... WE CAN CREATE A PROCEDURE FOR DISPLAYING OUTPUT.......................................EEEEEEEEEEEEEEEEEEEEE

SQL> CREATE OR REPLACE PROCEDURE DISPLAY(ARG VARCHAR2)
  2  AS
  3  BEGIN
  4  DBMS_OUTPUT.PUT_LINE(ARG);
  5  END;
  6  /

Procedure created.

SQL>
SQL> BEGIN
  2  DISPLAY('hai');
  3  END;
  4  /

PL/SQL procedure successfully completed.

SQL> SET SERVEROUTPUT ON
SQL> /
hai

PL/SQL procedure successfully completed.

SQL>
SQL> BEGIN
  2  DISPLAY('hai'||'HELLO');
  3  END;
  4  /
haiHELLO

PL/SQL procedure successfully completed.

No comments:

Post a Comment