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.
Смотрите видео PLSQL Introduction | First Program онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Technology with Kiran 22 Февраль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 55 раз и оно понравилось 2 людям.