DECLARETYPE myrecord IS RECORD(id varchar2(10),name varchar2(10));real_record myrecord;BEGINSELECT emp_id,emp_name INTO real_record FROM emp where emp_id='001';DBMS_OUTPUT.PUT_LINE(real_record.id||','||real_record.name);END;/
DECLARETYPE myrecord IS RECORD(id emp.eid%TYPE;--id字段和emp表中的eid的数据类型相同name varchar2(10));real_record myrecord;BEGINSELECT eid,ename INTO real_record FROM emp where eid='001';DBMS_OUTPUT.PUT_LINE(real_record.id||','||real_record.name);END;/
DECLAREmyrec emp%ROWTYPE;--定义myrec数据类型和表emp字段的数据类型都一致BEGINSELECT * INTO myrec FROM emp where eid='001';DBMS_OUTPUT.PUT_LINE(myrec.id||','||myrec.name);END;/
