Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Sunday, 3 April 2016

PL/SQL Data Types

The PL/SQL data types are divided into
Scalar Types: used to hold a single value; e.g. DATE, VARCHAR2, NUMBER etc.
Composite Types: used to hold one or more items of the same or dissimilar types; e.g. PL/SQL Records,VARRY
Reference Types: Similar to Pointers in C; e.g. REF Cursor
Large Objects (LOB): A large object can be either a binary or character value up to 4GB; e.g. BLOB, CLOB, NCLOB and BFILE
Share this article :


  1. Hi There,

    10/10 !!! Thank you for making your blogs an embodiment of perfection and simplicity. You make everything so easy to follow.

    I need some advice on loading delta records.. I am loading 15 tables from the PRODUCTION database to the Warehouse database. I want two previous years and the current year. Here is what i am doing , each table , i added a column called LOAD DATE=GETDATE(), When loading the next day i am using the where clause where LOADDATE is less than the GETDATE, Is this a correct approach?

    Appreciate your effort for making such useful blogs and helping the community.

    Many Thanks,
    Irene Hynes