createorreplaceprocedure query_emp
(num_empno in emp.empno%type,emp_name out emp.ename%type,emp_salary out emp.sal%type)isbeginselect ename,sal into emp_name,emp_salary
from emp where empno = num_empno;
exception
when no_data_found then
dbms_output.put_line('查询错误');end query_emp;
createorreplaceprocedure select_emp
(emp_name in emp.ename%type,emp_salary out emp.sal%type)isbeginselect sal into emp_salary from emp
where ename = emp_name;
exception
when no_data_found then
dbms_output.put_line(‘查询错误’);end select_emp;
1.创建一个过程,向dept表中添加一个新记录。(in参数)创建过程:create or replace procedure Insert_dept ( num_dept in number ,v_ename in varchar3)isbegin insert into dept values(num_dept,v_ename); commit;end ins...