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-...
🔗LINKS🔗
Website: http://rejawebs.com/#/
LinkedIn: / md-rezoyanul-islam-096a3775
►►► Find me on Social Media◄◄◄
Facebook: / rezoyanul.reza
✉ Contact with me
Email: rezaice07@gmail.com
❤ 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
In questa pagina del sito puoi guardare il video online What is PL/SQL | PL/SQL BLOCK della durata di ore minuti seconda in buona qualità , che l'utente ha caricato rejawebs 03 dicembre 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 384 volte e gli è piaciuto 4 spettatori. Buona visione!
