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博客 ” ，链接：https://blog.itpub.net/13941341/viewspace-624018/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
我的RECORD学习
下一篇：
收集相关的分析文件夹和上线文件
请登录后发表评论
登录
全部评论
