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;

Example 2 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