Friday, August 2, 2019

What is major difference between sql and plsql?

Oracle is combination of both SQL and PL/SQL

SQL is a Structured Query Language used to issue a single query or execute a single insert/update/delete.

PL-SQL is a  programming language SQL, used to write full programs using variables, loops,operators etc. to carry out multiple selects/inserts/updates/deletes.

SQL is a data oriented language used to select and manipulate sets of data.
PL/SQL is a procedural language used to create applications.

SQL is used to write queries, DDL and DML statements.
PL/SQL is used to write program blocks, functions, procedures triggers,and packages.

SQL is executed one statement at a time.
PL/SQL is executed as a block of code.

SQL can be embedded within a PL/SQL program.
But PL/SQL can’t be embedded within a SQL statement.



SQLPLSQL
It is a database Structured Query Language.It is a database programming language using SQL.
Data variable are not availableData variable are available.
No Supported Control Structures.Control Structures are available Like, For loop, While loop.
Query performs single operation.PLSQL block performs Group of Operation as single bloack.
SQL is declarative language.PLSQL is procedural language.
SQL can be embedded in PLSQL.PLSQL can be embedded in SQL.
It is directly interact with the database server.It is not interact with the database server.
It is Data oriented language.It is application oriented language.
It is used to write queries, DDL and DML statements.It is accustomed write program blocks, functions, procedures triggers,and packages.


 SQL                       PL SQL
SQL Stands for Structured Query language in which single SQL statement is executed at a time.PL SQL stands for Procedural Language Structured Query Language which is used as programming language in databases.
SQL simply used to perform DDLs (Data Definition Language) and DMLs with using single query at a time.PL SQL is nothing but the block of code embed with SQL statements which is used to add business logic with using programming concepts.
SQL is called as declarative language which is used to define what needs to be done.PL SQL is called as procedural language which is used to define how the things should be done.
SQL executes as a single statement.PL SQL executes as a block. The code of PL SQL is always written in to the block.
The main use of SQL statement is to process and manipulate the data. The SQL statements are mainly used for reporting purpose.PL SQL statements are used to perform the transactions to the databases. PL SQL is mainly used to build the application logic.
SQL directly interacts with database serverThere is no interaction between database server.
User can add SQL in to PL SQL statementsUser can not add PL SQL in to SQL statements

No comments:

Post a Comment

AME (Approval Management Engine)

AME (Approval Management Engine) : AME Stands for Oracle Approval Management Engine. AME is a self service web application that enables...