Collections:
Introduction to Oracle PL/SQL
Where to find answers to frequently asked questions about Oracle PL/SQL in general?
✍: FYIcenter.com
Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle PL/SQL in general. This FAQ can also be used as learning tutorials on creating procedures, executing procedures, using local variables, controlling execution flows, passing parameters and defining nested procedures.
Types of PL/SQL Code Blocks in Oracle
Define an Anonymous Block in Oracle
How Many Anonymous Blocks Can Be Defined in Oracle
Run the Anonymous Block Again in Oracle
What Is a Stored Procedure in Oracle
Create a Simple Stored Procedure in Oracle
Execute a Simple Stored Procedure in Oracle
Data Types Supported in PL/SQL in Oracle
Execution Flow Control Statements in Oracle
Use SQL Statements in PL/SQL in Oracle
Process Query Result in PL/SQL in Oracle
Create an Array in PL/SQL in Oracle
Manage Transaction Isolation Levels in Oracle
Example of Passing Parameters to Procedures in Oracle
Sample scripts used in this FAQ assumes that you are connected to the server with the HR user account on the default database instance XE. See other FAQ collections on how to connect to the server.
2019-03-27, 1757🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...