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

Pages

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 :

3 comments:

  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

    ReplyDelete
  2. Hello There,

    In total awe…. So much respect and gratitude to you folks for pulling off such amazing blogs without missing any points on the PL/SQL Data Types . Kudos!

    I have a table with column two columns

    Ex: Let us consider the two columns as below:
    Col1 Col2
    1 A
    2
    3
    4 D
    5

    My requirement is to get

    Col1 Col2
    1 A
    2 A
    3 A
    4 D
    5 D

    That is to update Col2 where it is null with the previous non null value as shown.

    Here it is only 5 records but it can vary

    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).

    Thanks a heaps,
    Preethi 

    ReplyDelete
  3. Hi There,

    Zoooooooom! That’s how speedy and easy this read was! Looking forward to more of such powerful content on PL/SQL Data Types !

    I need your help please, I am new at PL/SQL

    I need to run a select command with multiple values , if a break down this query into 3 pieces and run them,they works perfectly, but Ive got problems whenever i execute this query because there are multiple values into the where clause and i think its necessary to create lines break so it may work perfectly

    how can I get through this?

    SELECT job_name, command,description,days_of_week,start_mins,machine, J2.CREATE_STAMP, J2.MODIFY_STAMP
    FROM MDBADMIN.UJO_JOBROW JR JOIN MDBADMIN.ujo_job2 J2
    ON (JR.JOID = J2.JOID)
    WHERE job_name IN ('coscl_PM_zip_log','coscl_PM_clear_log','coscl_PM_alarma_fs','coscl_PM_pmapp1_PM_up','coscl_PM_control_recargas_cod_11','coscl_PM_control_recargas_ingreso','coscl_PM_control_rec_error_cc_agrup_v1'.'coscl_PM_control_procesos_diarios','coscl_PM_rep_recar_x_estado','coscl_PM_control_tiempos_recargas',
    'coscl_PM_control_porcentaje','coscl_PM_control_puertos_bloq','coscl_PM_control_errores', 'coscl_PM_control_java','coscl_PM_control_error_cache');

    Thank you very much and will look for more postings from you.

    Merci,
    Preethi.

    ReplyDelete