Oracle - Pl/SQL - Introduction in DBMS | PL/SQL Tutorial for beginners | Parnika Tutorials

In this video, i have discussed about pl/sql like disadvantages of oracle sql, features of pl sql, structure of pl/sql.
"Oracle - Pl/SQL - Introduction in DBMS | PL/SQL Tutorial for beginners
#plsql #pl/sql #sql #oracle/plsql #plsqltutorials #pl/sqltutorials #oraclepl/sql #pl/sqltutorials2023 #SQLTutorial2023 #SQL #SQLTraining #SQLServerTutorials #SQLServerCourse

#sqltrainingvideos #sqlservertraining #sqlservertutorialvideos #SQLServer #parnikatutorials

00:08 - introduction pl/sql
01:37 - plsql
02:38 - block structure
03:10 - features
03:57 - single command
04:18 - exception handling block
05:17 - function of packages
05:56 - PLSQL sTRUCTURE
06:29 - plsql blocks
07:04 - declaration section
07:55 - declaration examples
08:15 - execution section
09:01 - supported commands
09:54 - exception
11:53 - conclusion"
PL/SQL is a block structured language that enables developers to combine the power of SQL with procedural statements.
All the statements of a block are passed to oracle engine all at once which increases processing speed and decreases the traffic.

Disadvantages of SQL:

SQL doesn’t provide the programmers with a technique of condition checking, looping and branching.
SQL statements are passed to Oracle engine one at a time which increases traffic and decreases speed.
SQL has no facility of error checking during manipulation of data.

Features of PL/SQL:

PL/SQL is basically a procedural language, which provides the functionality of decision making, iteration and many more features of procedural programming languages.
PL/SQL can execute a number of queries in one block using single command.
One can create a PL/SQL unit such as procedures, functions, packages, triggers, and types, which are stored in the database for reuse by applications.
PL/SQL provides a feature to handle the exception which occurs in PL/SQL block known as exception handling block.
Applications written in PL/SQL are portable to computer hardware or operating system where Oracle is operational.
PL/SQL Offers extensive error checking.

Structure of PL/SQL Block:

PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL.
The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other.

Typically, each block performs a logical action in the program. A block has the following structure:

DECLARE
declaration statements;

BEGIN
executable statements

EXCEPTIONS
exception handling statements

END;
Declare section starts with DECLARE keyword in which variables, constants, records as cursors can be declared which stores data temporarily. It basically consists definition of PL/SQL identifiers. This part of the code is optional.

Execution section starts with BEGIN and ends with END keyword.
This is a mandatory section and here the program logic is written to perform any task like loops and conditional statements. It supports all DML commands, DDL commands and SQL*PLUS built-in functions as well.
Exception section starts with EXCEPTION keyword.
This section is optional which contains statements that are executed when a run-time error occurs. Any exceptions can be handled in this section.

Social media Links:
To get the regular updates:
Playlists:
Virtual Coffee with Jagadeesh:
Digital Logic Design:
Computer Organization and Architecture:
C Programming:
Data Structures:

Theory of Computation:

Compiler Design:

Computer Networks:
For GATE PYQs and much more explore: