返回值:
l
NULL 没有SELECT或DML运行
l
TRUE 如果SELECT或DML返回或影响了一行或多行
l
FALSE 其他情况
DROP TABLE dept_temp;
CREATE TABLE dept_temp AS SELECT * FROM departments;
CREATE OR REPLACE PROCEDURE P (dept_no NUMBER) AS
BEGIN
DELETE FROM dept_temp
WHERE department_id = dept_no;
IF SQL%FOUND THEN
DBMS_OUTPUT.PUT_LINE ('Delete succeeded for department number ' || dept_no);
ELSE
DBMS_OUTPUT.PUT_LINE ('No department number ' || dept_no);
GBase 8s PL/SQL手册
南大通用数据技术股份有限公司
- 96 -
END IF;
END;
BEGIN
p(270);
p(400);
END;
--Result:
--Delete succeeded for department number 270
--No department number 400