Oracle Database Interview Question:

How To Create a Stored Program Unit?

Submitted by: Administrator

If you want to create a stored program unit, you can use the CREATE PROCEDURE or FUNTION statement. The example script below creates a stored program unit:

SQL> set serveroutput on;

SQL> CREATE PROCEDURE Hello AS
2 BEGIN
3 DBMS_OUTPUT.PUT_LINE('Hello world!');
4 END;
5 /
Procedure created.
Submitted by: Administrator