Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Tuesday, 9 July 2013

Advantages of PL/SQL and their Data Types


There are some Advantages of PL/SQL and their Data Types, just reading them.
Advantages of PL/SQL and their Data Types
PL/SQL
PL/SQL stands for Procedural Language/SQL.PL/SQL extends SQL by adding control Structures found in other procedural language.PL/SQL combines the flexibility of SQL with Powerful feature of 3rd generation Language. The procedural construct and database access Are present in PL/SQL.PL/SQL can be used in both in database in Oracle Server and in Client side application development tools.

Advantages of PL/SQL
Support for SQL, support for object-oriented programming,, better performance, portability, higher productivity, Integration with Oracle
a] Supports the declaration and manipulation of object types and collections.
b] Allows the calling of external functions and procedures.
c] Contains new libraries of built in packages.
d] With PL/SQL , an multiple sql statements can be processed in a single command line statement.