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
to write a heap sort program usin pl-sql

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

Literature review

What is Cursors how to use it in Real time application ?

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Implicit Cursors The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recen