Chapter 16 Procedure

Chapter 16 Procedure

create or replace procedure proc_helloworld
is
begin
     DBMS_OUTPUT.Put_Line('Hello World');
end;

/

Procedure created

SQL> show serveroutput
SQL> set serveroutput on
SQL> show serveroutput
SQL> exec proc_helloworld
Hello World

PL/SQL procedure successfully completed


SQL> begin
  2       proc_helloworld;
  3  end;
  4  /
Hello World

PL/SQL procedure successfully completed


SQL> DROP PROCEDURE proc_helloworld;

Procedure dropped

select object_name,object_type, status
from user_objects
where object_type = 'PROCEDURE';

SELECT DBMS_METADATA.get_ddl ('PROCEDURE', 'PROC_HELLOWORLD') from dual;

SELECT text FROM user_source WHERE NAME = 'PROC_HELLOWORLD';

编写、创建、运行、修改、调试、删除

Come on,Guys!