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, 1847🔥, 0💬
Popular Posts:
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...