PL/SQL Records and Object Records

Posted on 2007-08-07
Last Modified: 2013-12-07
How can PL/SQL Records and Object Record types be used in the real world?  Any examples you have to provide would be helpful in my understanding.
Question by:khall16
    1 Comment
    LVL 27

    Accepted Solution

    Record Types:
    Say you have an Entity Set with a lot of attributes and your program calculates/derives these values based on different conditions. You can get this done using a number of arrays for each attributes. But tracking the array indexes all thru your program becomes difficult and error-prone depending on the complexity of the code. Record types comes handy here. You logically group the attributes of your Entity Set to a Record Type. So you can have a single array of records with each element holding an entity with a number of attributes.

    Object Types:
    Object Types are similar to record types, in the capabilities of holding multiple attributes, it has extra features that
    - you can have object types as a column in a database table.
    - You can create object type tables
    - YOu can associate methods with object types n so on

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to recover a database from a user managed backup

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now