SQL>
SQL> DECLARE
2 TYPE hrc_company_rec IS RECORD
3 (hrc_company_id NUMBER,
4 product_description VARCHAR2(20),
5 company_short_name VARCHAR2(30));
6 v_example_rec hrc_company_rec;
7 BEGIN
8 v_example_rec.hrc_company_id :=1001;
9
10 v_example_rec.product_description :='C';
11
12 v_example_rec.company_short_name :='O Inc.';
13
14 dbms_output.put_line(to_number(v_example_rec.hrc_company_id)||' '||
15
16 v_example_rec.product_description||' '||
17
18 v_example_rec.company_short_name);
19 END;
20 /
1001 C O Inc.
PL/SQL procedure successfully completed.
SQL>