Back to photostream

Quick Scoop on SQL, PL/SQL:

 

 

SQL:

 

- SQL stands for structured Query Language. It is used for querying relational databases.

- It is a user-friendly, easy to interpret programming language that can be used for programming in relational databases.

- It has a wide set of keywords & functionalities to design the instructions called queries.

 

PL/SQL:

 

- PL/SQL stands for "Procedural Language extension of SQL"

- PL/SQL is a block-structured language.

- The programs of PL/SQL are logical blocks that can contain any number of nested sub-blocks.

- PL/SQL is integrated with the Oracle database (since version 7).

- The functionalities of PL/SQL usually extend after each release of the Oracle database.

- Although PL/SQL integrates with SQL language, it adds some programming constraints that are not available in SQL.

 

3 views
0 faves
0 comments
Uploaded on January 27, 2021