Oracle定义数据类型Type - 数据库编程

owtype(3).age||', '||'sex:'||v_tbl_rowtype(3).sex||', '||'grade:'||v_tbl_rowtype(3).grade);

end;

输出结果：

------------基本类型VARCHAR2表记录------------
zhansan
lisi
wanwu
------------自定义RECORD类型表记录------------

name:zhansan, age:12, sex:1
name:lisi, age:23, sex:1
name:wanwu, age:32, sex:1
------------表记录类型表记录------------------
name:zhansan, age:12, sex:1, grade:643
name:lisi, age:23, sex:1, grade:445
name:wanwu, age:32, sex:1, grade:545

Oracle定义数据类型Type(二)