PL/SQL Programmer Defined Records

PL/SQL Programmer Defined Records

These are records in which you, the programmer, define a record type.

Example 1 of Programmer Defined Records
Type my_first_record is record (
 Name Varchar2(20);
 Age Number;
 Salary Number;);
var_of_myfirstrecord my_first_record;

DECLARE
 TYPE employee_rectype IS RECORD (
 emp_id  Number(10) NOT NULL
       ,dept_no  dept.dept%TYPE
       ,name  empname_rectype
       ,hire_date DATE:=SYSDATE);

new_emp_rec employee_rectype;

BEGIN
 Do Some Processing...
END;

Example 2 of Programmer Defined Records
Type my_first_record is record (
Name varchar2(20);
Age number;
Salary number;);
Var_of_myfirstrecord my_first_record;

Example 3 of Programmer Defined Records
DECLARE
TYPE employee_rectype IS RECORD (
emp_id       NUMBER(10) NOT NULL
,dept_no     dept.deptno%TYPE
,n?me        empn?me_rectype
,hire_d?te   DATE := SYSDATE);
new_emp_rec employee_rectype;
BEGIN

Posted in: PL/SQL tutorial pdf