PL/SQL- Pl/SQL stand for procedural language by structure query language and it is the combination of procedural language statement and SQL.
It has following activities
1-PL/SQL is not a case sensitive language
2-In SQL we can not execute more than one statement repeatedly to particular number of times.
3-But whereas in PL/SQL we can execute the same statement repeatedly to particular number of times because it support looping mechanism.
4-In SQL we can not execute more than one statement simultaneously but whereas in PL/SQL wecan execute more than statement.
5-PL/SQL support all the principles of procedural language concept so we can easily execute the all statement.
6-PL/SQL is a high performance transaction processing language
It has following activities
1-PL/SQL is not a case sensitive language
2-In SQL we can not execute more than one statement repeatedly to particular number of times.
3-But whereas in PL/SQL we can execute the same statement repeatedly to particular number of times because it support looping mechanism.
4-In SQL we can not execute more than one statement simultaneously but whereas in PL/SQL wecan execute more than statement.
5-PL/SQL support all the principles of procedural language concept so we can easily execute the all statement.
6-PL/SQL is a high performance transaction processing language
No comments:
Post a Comment