Oracle 記錄類型變量.doc

Oracle 記錄類型變量-編寫(xiě)一段程序，可以實(shí)現(xiàn)從鍵盤(pán)輸入一個(gè)雇員工號(hào)，就 可以查詢?cè)摴蛦T的姓名，工資和崗位。declare v_rowemp scott.emp%rowtype;beginselect * into v_rowemp from scott.emp where empno=&no;dbms_output.put_line(姓名|v_rowemp.ename|工資|v_rowemp.sal|崗位|v_rowemp.job);end;-記錄類型declaretype emp_record is record (name scott.emp.ename%type, sal scott.emp.sal%type, job scott.emp.job%type);v_record emp_record;beginselect ename,sal,job into v_record from scott.emp where empno=&no;dbms_output.put_line(v_| |v_record.sal| |v_record.job);end;-declaretype emp_record is record (name scott.emp.ename%type, sal scott.emp.sal%type, job scott.emp.job%type);v_record emp_record;beginselect ename,sal,job into v_,v_record.sal,v_record.job from scott.emp where empno=&no;dbms_output.put_line(v_| |v_record.sal| |v_record.job);end;-賦值語(yǔ)句declaretype emp_record is record (name scott.emp.ename%type, sal scott.emp.sal%type, job scott.emp.job%type);v_record1 emp_record;v_record2 emp_record;beginselect ename,sal,job into v_record1 from scott.emp where empno=&no;v_record2:=v_record1;dbms_output.put_line(v_| |v_record1.sal| |v_record1.job);dbms_output.put_line(v_| |v_record2.sal| |v_record2.job);end;-表達(dá)式類型錯(cuò)誤declaretype emp_record is record (name scott.emp.ename%type, sal scott.emp.sal%type, job scott.emp.job%type);v_record1 emp_record;type emp_record1 is record (name scott.emp.ename%type, sal scott.emp.sal%type, job scott.emp.job%type);v_record2 emp_record1;beginselect ename,sal,job into v_record1 from scott.emp where empno=&no;v_record2:=v_record1;dbms_output.put_line(v_| |v_record1.sal| |v_re