摘要： 1. % type 用法，提取% type所在字段的类型declare myid dept.deptno % type; myname dept.dname % type;begin select deptno, dname into myid, myname from dept where deptno = 10; dbms_output.put_line(myid); dbms_output.put_line(myname);end;2. % rowtype 用法，提取% rowtype所在字段的类型declare type type_dept is table of dept % r.. 阅读全文