Pages

Showing posts with label SQL v/s PLSQL. Show all posts
Showing posts with label SQL v/s PLSQL. Show all posts

Difference between SQL and PLSQL

S NoSQLPLSQL
1
STRUCTURED QUERY LANGUAGE
PROCEDURAL LANGUAGE/SQL
2
It is a collection of predefined commands
programs.
It is a collection of user defined
commands programs
3
One query is executed at a time
as a block.
collection of queries can be executed
4
each query terminated with semi colon(;)each block terminated with END;
5
queries are not case sensitivenot case sensitive



Difference between SQL and PLSQL

S No SQL PLSQL
1
STRUCTURED QUERY LANGUAGE
PROCEDURAL LANGUAGE/SQL
2
It is a collection of predefined commands
programs.
It is a collection of user defined
commands programs
3
One query is executed at a time
as a block.
collection of queries can be executed
4
each query terminated with semi colon(;)each block terminated with END;
5
queries are not case sensitivenot case sensitive



Featured post

Snowflake - Creating warehouse in Snowflake

Creating warehouse Login to Snowflake and click on warehouse and click on Create fill the necessary details and click Finish We can also c...