Live ORACLE

DECLARE

  TYPE recordtyp IS RECORD(field1 NUMBER,

                            field2 VARCHAR2(32) DEFAULT 'something');

   rec1  RECORDTYP;

   rec2  RECORDTYP;

BEGIN

  -- At first, rec1 has the values we assign.

  rec1.field1 := 100;

 

  rec1.field2 := 'something else';

 

  -- Assigning an empty record to rec1 resets fields to their default values.

  -- Field1 is NULL and field2 is 'something' due to the DEFAULT clause

  rec1 := rec2;

 

  dbms_output.Put_line('Field1 = '

                       ||Nvl(To_char(rec1.field1),'')

                       ||',
field2 = '

                       ||rec1.field2);

END;

/

Assigning Default Values to a Record