Hello instance for Oracle pl/SQL programming

The plsql block that only contains the execution part setserveroutputon -- open the output option begindbms_output.put_line (

Only pl/SQL block including execution part set serveroutput on -- open the output option begin dbms_output.put_line (

Pl/SQL block that only contains the execution part

Set serveroutput on -- enable output options

Begin

Dbms_output.put_line ('hello ');

End;

Instructions:

Dbms_output is a package provided by Oracle locks (similar to java). This package contains some processes. put_line is a process in the dbms_output package.

The set serveroutput on Clause indicates that the output result is opened. If this clause is not provided, the result will not be output.

Set serveroutput off is the output result.

This simple pl/SQL block programming is complete.