PLSQL Introduction | First Program

Publicado em: 22 Fevereiro 2024
no canal de: Technology with Kiran

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.

Nesta página do site você pode assistir ao vídeo on-line PLSQL Introduction | First Program duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Technology with Kiran 22 Fevereiro 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 55 vezes e gostou 2 espectadores. Boa visualização!

465