Collections:
PL/SQL Procedure in Oracle
What Is a Procedure in Oracle?
✍: FYIcenter.com
A procedure is a named program unit. It consists of three parts:
Here how a complete procedure should look like:
PROCEDURE name (parameter_1, parameter_2) AS -- Declaration statements BEGIN -- Executable statements EXCEPTION -- Error handling statements END;
⇐ PL/SQL Named Program Unit in Oracle
2018-11-29, 1574🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...