PL/SQL Records and Object Records

Posted on 2007-08-07
Medium Priority
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

sujith80 earned 150 total points
ID: 19651431
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

850 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