Data Types in Pl/SQL and SQL

A)Scalar Types :- They are Predefined by oracle.

They are classified as

1)Integer

2)Character

3)Date

4)Boolean

B)Composite Types:-They are used mostly in ORDMS(Table,varray).

Record-

%ROWTYPE

In PL/SQL, records are used to group data. A record consists of a number of related

fields in which data values can be stored. The %ROWTYPE attribute provides a record

type that represents a row in a table. The record can store an entire row of data

selected from the table or fetched from a cursor or cursor variable .Even though datatypes of each field is different it considers al of them as a single logical unit.

3)Reference Types:-Used in cursors

4)Lob types:-Used to store huge amount of data

a)BLob-used to store binary data like images,audio .Size is 4gb

b)CLob - used to store character data like files etc Size is 4gb