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
Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Declaring Exceptions The Exceptions can be declared only in the declarative part of the PL/SQL subprogram, block, or package. By introducing its name, you can declare an excep

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o

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

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the