What is a record, PL-SQL Programming

What Is a Record ?

A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an employee like name, hire date, and salary. These items are logically associated but dissimilar in type. The record containing a field for each item lets you treat the data as a logical unit. Consequently, records make it easier to organize and represent the information.

The attribute %ROWTYPE declare a record that presents a row in the database table. Though, you cannot specify the datatypes of the fields in the record or declare the fields of your own. The datatype RECORD lifts these restrictions and define your own records.

Posted Date: 10/4/2012 3:33:51 AM | Location : United States







Related Discussions:- What is a record, Assignment Help, Ask Question on What is a record, Get Answer, Expert's Help, What is a record Discussions

Write discussion on What is a record
Your posts are moderated
Related Questions
Defining REF CURSOR Types To make cursor variables, you take 2 steps. At first, you define a REF CURSOR type, and then declare the cursor variables of that type. You can defin

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

Inserting Objects: You can use the INSERT statement to add objects to an object table. In the illustration below, you insert a Person object into the object table persons:

Entering and Exiting If you enter the executable part of an autonomous routine, the major transaction suspends. When you exit the routine, the major transaction resumes. To ex

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

What are 3 good practices of modeling and/or implementing data warehouses?

Project Description: This is stage 1 of a larger conversion project. We are converting a traditional Server/Client application written in Access 2007 into a web interface with S

to write a heap sort program usin pl-sql

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Use of Table Expressions - Expressing Constraint Conditions With the exception of key constraints, the examples in the theory book all explicitly reference at least one relvar