储存过程入门05--复合变量

DECLARE
TYPE myrecord IS RECORD(
id varchar2(10),
name varchar2(10));
real_record myrecord;
BEGIN
SELECT emp_id,emp_name INTO real_record FROM emp where emp_id='001';
DBMS_OUTPUT.PUT_LINE(real_record.id||','||real_record.name);
END;
/

 

 

DECLARE
TYPE myrecord IS RECORD(
id emp.eid%TYPE;--id字段和emp表中的eid的数据类型相同
name varchar2(10));
real_record myrecord;
BEGIN
SELECT eid,ename INTO real_record FROM emp where eid='001';
DBMS_OUTPUT.PUT_LINE(real_record.id||','||real_record.name);
END;
/

 

 

DECLARE
myrec emp%ROWTYPE;--定义myrec数据类型和表emp字段的数据类型都一致
BEGIN
SELECT * INTO myrec FROM emp where eid='001';
DBMS_OUTPUT.PUT_LINE(myrec.id||','||myrec.name);
END;
/