PL/SQL
-
编辑 删除
例子
例子1：查询雇员编号为7788雇员姓名和工资DECLARE v_name VARCHAR2(10); v_sal NUMBER(5);BEGIN SELECT ename,sal INTO v_name,v_sal FROM emp WHERE empno=7788; DBMS_OUTPUT.PUT_LINE('7788号雇员是：'||v_name||',工资为：'||to_char(v_sal));END;记录：TYPE r_record is record( v_name emp.ename%TYPE, v_job emp.job%TYPE, v_sal emp.sal%TYPE);变量定义：r_emp r_record; r_employee r_record;变量赋值：select ename,job,sal INTO r_emp from emp where empno=7934;或：r_employee.v_ename:='JACK';r_employee.v_job:='CLERK';r_e
