set echo off
set serveroutput on
declare
type a1_record_type is record
(a11 number,
a12 number);
type a2_record_type is record
(a21 number,
a1 a1_record_type);
b1 a1_record_type;
b2 a2_record_type;
begin
b1.a11 := 100;
b1.a12 := 200;
dbms_output.put_line(to_char(b1.a11)||'...'||to_char(b1.a12));
b2.a21 := 300;
b2.a1.a11 := 400;
b2.a1.a12 := 500;
dbms_output.put_line(to_char(b2.a21)||'...'||to_char(b2.a1.a11)||'...'||to_char(b2.a1.a12));
end;
/
set serveroutput off
set echo on
set serveroutput on
declare
type a1_record_type is record
(a11 number,
a12 number);
type a2_record_type is record
(a21 number,
a1 a1_record_type);
b1 a1_record_type;
b2 a2_record_type;
begin
b1.a11 := 100;
b1.a12 := 200;
dbms_output.put_line(to_char(b1.a11)||'...'||to_char(b1.a12));
b2.a21 := 300;
b2.a1.a11 := 400;
b2.a1.a12 := 500;
dbms_output.put_line(to_char(b2.a21)||'...'||to_char(b2.a1.a11)||'...'||to_char(b2.a1.a12));
end;
/
set serveroutput off
set echo on
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13941341/viewspace-624018/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13941341/viewspace-624018/