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 without registration, duration hours minute second in high quality. This video was added by user Technology with Kiran 22 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 55 once and liked it 2 people.