PLSQL Introduction | First Program
1. PL / SQL:
1 PL/SQL is a procedural extension to a non – procedural language SQL.
2 PL/SQL is a Database Language restricted only to do the database activities. ( Unlike Other General Purpose Languages like C, C++, Java, Etc )
3 PL/SQL Can Have Any Number of Statements, Which Reduces The Network Traffic.
4 PL/SQL Program can reside either at the front end or within Oracle Database Server as Stored Subprogram.
5 Named PL/SQL Sub-Programs that can be stored within the database are Procedures, Functions, Triggers and Packages.
Valid SQL Statements in PL/SQL:
1 All DML Statements ( Insert, Update, Delete)
2 All TCL ( Commit, Rollback)
3 All SQL Functions ( Single & Group function)
4 All SQL Predicates ( Where, Having, Group By, Order by)
Invalid SQL Statements in PL/SQL Are:
1 DDL Statements ( Create, Alter, Etc)
2 DCL Statements ( Grant, Revoke)
Types of Procedural Statements in PL/SQL:
1 Flow Control Statements: If, Exit, Goto, Raise.
2 Iterative Statements: Simple Loop, While Loop, For Loop.
Benefits of PL/SQL
1 Integration.
2 Modularized Application Development.
3 Improved Performance.
4 Provides Exception / Error Handling Capability.
5 Reusability of Code.
6 Provides Encapsulation, Overloading, etc.
Watch video PLSQL Introduction | First Program online, duration hours minute second in high quality that is uploaded to the channel Technology with Kiran 22 February 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 55 times and liked it 2 visitors.
