PL/SQL Programmer Defined Records

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