Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - What Is PL/SQL
(Continued from previous topic...)
What Is PL/SQL?
PL/SQL is a modern, block-structured programming language. It provides several
features that make developing powerful database applications very convenient. For
example, PL/SQL provides procedural constructs, such as loops and conditional
statements, that are not available in standard SQL.
PL/SQL code runs on the server, so using PL/SQL lets you centralize significant parts
of your database applications for increased maintainability and security. It also enables
you to achieve a significant reduction of network overhead in client/server
(Continued on next topic...)
- What Is PL/SQL?
- What Are the Types PL/SQL Code Blocks?
- How To Define an Anonymous Block?
- How Many Anonymous Blocks Can Be Defined?
- How To Run the Anonymous Block Again?
- What Is a Stored Program Unit?
- How To Create a Stored Program Unit?
- How To Execute a Stored Program Unit?
- How Many Data Types Are Supported?
- What Are the Execution Flow Control Statements?
- How To Use SQL Statements in PL/SQL?
- How To Process Query Result in PL/SQL?
- How To Create an Array in PL/SQL?
- How To Manage Transaction Isolation Level?
- How To Pass Parameters to Procedures?
- How To Define a Procedure inside Another Procedure?
- What Do You Think about PL/SQL?