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
Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

Need Database Development with Analysis Tools Project Description: I want a database for large governmental and private data sets on one country that can be simply extended t

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:

Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

Semidifference via NOT IN and a subquery SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' AND StudentId NOT IN (SELECT StudentId FROM IS_ENROLLED_ON WHER

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

Usefulness of Data Type In SQL, as in most computer languages, a type can be used for constraining the values that are permitted to be used for some purpose. In particular, i

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

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