RECORDS

• It's not table Record.
• It is an user defined type.
• A record is a collection of different datatypes from different tables it is acting like structure in C programming language.

SYNTAX:

type <type_name> is record(element1 <datatype>(size),

                                              element2 <datatype>(size),

                                              element3 <datatype>(size) 

                                               .

                                               .      

                                               element n <datatype>(size));

EXAMPLE:

type emp_rec is record(empno number,ename varchar2(15),sal number);

Program Using Record:

declare

type emp_rec is record(

Empno number(5),

Ename varchar2(15),

Bsal number(5),

Hra number(5),

Da number(5),

Pf  number(5),

Tax number(5),

Gross number(5),

Net number(5));

e emp_rec;

Begin

e.empno:=&Empno;

select Ename,Sal,into e,Ename,e.Bsal from emp where Empno=e.empno;

e.Da:=e.Bsal*0.25;

e.Hra:=e.Bsal*0.35;

e.Pf:=e.Bsal*0.15;

e.tax:=e.Bsal*0.10;

e.gross:=(e.Bsal+e.Da+e.Hra);

e.net:=e.gross-(e.Pf+e.Tax);

dbms_output,put_line(e.Empno||' '||e.Ename||' '||e.Gross||' '||e.net);

End;