Oracle 记录类型变量.doc

Oracle 记录类型变量-编写一段程序，可以实现从键盘输入一个雇员工号，就 可以查询该雇员的姓名，工资和岗位。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;-赋值语句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;-表达式类型错误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