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:
Instagram: / parnikatutorials
Website: http://parnikatutorials.in/
Email id: parnikatutorials@gmail.com
To get the regular updates:
Telegram link: https://t.me/Parnikatutorials
Facebook: https://m.facebook.com/profile.php?id...
Linkedin: / parnika-tutorials-a8a9831b2
Pinterest: / parnikatutorials0892
Playlists:
Virtual Coffee with Jagadeesh:
• VIRTUAL COFFEE WITH JAGADEESH
Digital Logic Design:
• Digital Logic Design
Computer Organization and Architecture:
• ABOUT PARNIKA TUTORIALS
C Programming:
• L 1: WHAT IS AN ALGORITHM AND CHARACT...
Data Structures:
• L 1: Uncover the Benefits of Linked L...
Theory of Computation:
• ABOUT PARNIKA TUTORIALS
Compiler Design:
• ABOUT PARNIKA TUTORIALS
Operating Systems: • PROCESS STATE DIAGRAM | LONG TERM, SH...
Databases: • ABOUT PARNIKA TUTORIALS
Computer Networks:
• ABOUT PARNIKA TUTORIALS
For GATE PYQs and much more explore:
/ parnikatutorials
On this page of the site you can watch the video online Oracle - Pl/SQL - Introduction in DBMS | PL/SQL Tutorial for beginners | Parnika Tutorials with a duration of hours minute second in good quality, which was uploaded by the user Parnika Tutorials 03 September 2022, share the link with friends and acquaintances, this video has already been watched 699 times on youtube and it was liked by 9 viewers. Enjoy your viewing!
