Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
SQL is structured query language to perform data manipulation on database objects, especially tables and views.
PL SQL is procedural language to write advanced logical database objects in oracle database, working as a native language to oracle database.
The SQL is Structure Query Language for managing data held in a relational database management system (RDBMS)
The PL-SQL is a proprietary procedural language used by Oracle
SQL is the standard of structure query language (SQL) while PL/SQL (Procedural Language/Structured Query Language) is ORACLE delegate of SQL , and it is dedicated to develop SQL and PL/SQL includes procedural language elements such as Conditions and loops, It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces
PL/SQL is a procedural language used to write programmable blocks for Oracle RDBMS. On the other hand, SQL is a special interpreted language used to obtain and manage data in RDBMS.
1.) SQL is a data oriented language for selecting and manipulating sets of data. PL/SQL is a procedural language to create applications.
2.) PL/SQL can be the application language just like Java or PHP can. PL/SQL might be the language we use to build, format and display those screens, web pages and reports.SQL may be the source of data for our screens, web pages and reports.
3.) SQL is executed one statement at a time. PL/SQL is executed as a block of code.
4.) SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).
5.) SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions, procedures and packages.
6.) We can embed SQL in a PL/SQL program, but we cannot embed PL/SQL within a SQL statement.
SQL is used to write queries,DML and DDL statements and is executed once at a time while PL/SQL is procedural language which is used to create applications basically used to write functions,procedures,blocks and packages etc.
- SQL is used to write queries, DDL and DML statements.
- PL/SQL is used to write programs, views, functions, procedures and triggers
SQL is a data oriented language for selecting and manipulating data in RDBMS while PL/SQL is a procedural language to create programmable blocks or applications.
SQL- it is a structure query language. use to write the query to retrieve, update, modify, add the data from database by using commands(DDL, DML, DCL)
PL SQL- it is a procedural language. it is used to create stored procedure, user define function ,trigger etc.