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.
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