Pages

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



No comments:

Post a Comment

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...