Collections:
Create a Simple Stored Procedure in Oracle
How To Create a Stored Program Unit in Oracle?
✍: FYIcenter.com
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.
Â
2019-03-20, 2381👍, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...