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.
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.
SQL | PLSQL |
---|---|
It is a database Structured Query Language. | It is a database programming language using SQL. |
Data variable are not available | Data 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 server | There is no interaction between database server. |
User can add SQL in to PL SQL statements | User can not add PL SQL in to SQL statements |
No comments:
Post a Comment