What is PL/SQL | PL/SQL BLOCK

►►► Title: What is pl/sql | PL/SQL BLOCK

►►► Contents:
What is pl/sql?
-------------------
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.
PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since version 7)

PL/SQL block:
-------------
A PL/SQL block is defined by the keywords DECLARE , BEGIN , EXCEPTION , and END.
These keywords partition the block into a declarative part, an executable part, and an exception-handling part.

DECLARE (OPTIONAL)
BIGIN (MENDATORY)

EXCEPTION (OPTIONAL)
END;(MENDATORY)


Anonymous Blocks:
-----------------

--Executing NULL;
DECLARE
BEGIN
NULL;
END;

--Let's output "Hello PL/SQL". Before doing the we need to execute SET serveroutput on in this current session.

SET serveroutput ON;
/
DECLARE
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello PL/SQL');
END;
/

?Description Link?: https://github.com/rezaice07/youtube-channel/blob/main/rejawebs/oracle/PLSQL/01_Annonymus_Block/01_annonymus_block.txt

?LINKS?
Website: http://rejawebs.com/#/
LinkedIn: https://www.linkedin.com/in/md-rezoyanul-islam-096a3775/

►►► Find me on Social Media◄◄◄
Facebook: https://www.facebook.com/rezoyanul.reza

✉ Contact with me
Email: [email protected]

❤ Make sure you SUBSCRIBE and be the 1st one to view newly created videos!

Hope you guys enjoyed this tutorial..
Don't forget to subscribe my channel.
Keep watching the next tutorial.
Thanks