end;
/
单独 selectdeclare
l_empno emp.EMPLOYEE_ID%type;
-- l_ename emp.ename%type;
begin
select EMPLOYEE_ID
into l_empno
from emp;
--where rownum =1;
dbms_output.put_line(l_empno);
end;
/
使用INTO获取值，只能返回一行。
错误处理：exception
when <exception_expression> then
…
when <exception_expression> then
…
end;
exception_expression包括：
1. 预定义表达式
2. 用户定义表达式
3. PRAGMA EXCEPTION_INIT
预定义declare
l_dept departments%rowtype;
begin
l_dept.department_id:=100;
l_dept.department_name:=’HR’;
insert into departments(department_id, department_name)
values(l_dept.department_id, l_dept.department_name);
Exception
When DUP_VAL_ON_INDEX then
Dbms_output.put_line(‘heihei’);
end;
/
DUP_VAL_ON_INDEX 异常
Exception
When DUP_VAL_ON_INDEX then
&nb
