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
Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

Data Types in SQL - Timestamp TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

THEO R Y OF CATASTROPHISM OR CATALYSM (CUVIER 1769-1832) - The world has passed thorugh several stages and at the end of each stage there was a catastrophe killing all the

Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp

Bulk Fetching The illustration below shows that you can bulk-fetch from a cursor into one or more collections: DECLARE TYPE NameTab IS TABLE OF emp.ename%TYPE; TYPE S

Use Native Dynamic SQL A few programs (a normal-purpose report writer for illustration) should build and process a variety of SQL statements at run time. Therefore, their full

Blocks: The fundamental program unit in the PL/SQL is the block. The PL/SQL block is defined by the keywords BEGIN, DECLARE, EXCEPTION, and END. These keywords partition the b

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Substitution and Instantiation - SQL It shows how NULL might appear in substitution for a parameter of a predicate and how it might thus participate in instantiation of that p