Collections:
PL/SQL Anonymous Block in Oracle
What Is an Anonymous Block in Oracle?
✍: FYIcenter.com
An anonymous block is a PL/SQL code block with no name. It consists of three parts:
Here how a complete anonymous block should look like:
DECLARE -- Declaration statements BEGIN -- Executable statements EXCEPTION -- Error handling statements END;
⇒ PL/SQL Named Program Unit in Oracle
⇐ Different Types of PL/SQL Code Blocks in Oracle
2018-11-29, 1648🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...