Collections:
Execute a Simple Stored Procedure in Oracle
How To Execute a Stored Program Unit in Oracle?
✍: FYIcenter.com
If you want to execute a stored program unit, you can use the EXECUTE statement. The example script below shows how to executes 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. SQL> EXECUTE Hello; Hello world!
2019-03-20, 721👍, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......