Advantages of PL/SQL and their Data Types

There are some Advantages of PL/SQL and their Data Types, just reading them.

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 3^rd 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.

PL/SQL Datatypes

Scalar Types :

BINARY_INTEGER ,DEC,DECIMAL,DOUBLE ,,PRECISION,FLOAT,INT,INTEGER,NATURAL, NATURALN,NUMBER, NUMERIC, PLS_INTEGER,POSITIVE,POSITIVEN,REAL,SIGNTYPE, SMALLINT,CHAR,CHARACTER,LONG,LONG RAW,NCHAR,NVARCHAR2,RAW,ROWID,STRING, VARCHAR,VARCHAR2,

Composite Types:

TABLE, VARRAY, RECORD

LOB Types

BFILE, BLOB, CLOB, NCLOB

Reference Types

REF CURSOR

BOOLEAN, DATE

DBMS_OUTPUT.PUT_LINE:

It is a pre-defined package that prints the message inside the parenthesis