Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Introducing the Main Data type Groups

There are four main groups: Scalar datatypes represent single values that can't be divided into parts. Composite datatypes include internal components that can be manipulated independently. %ROWTYPE is an example of the PL/SQL RECORD datatype. References contain pointers to other program items. Large objects store or point to large amounts of textual or binary information, such as images, movies, or books. Scalar datatypes are divided into families: Numeric datatypes. Character datatypes. Date/time datatypes. Boolean datatypes.