AA就可以把要了,在存储过程中直接写成语句就行了CREATE OR REPLACE PROCEDURE test(
BB IN NUMBER(8),
CC IN NUMBER(8),
id OUT yourtablename.id%TYPE,--表中的字段
name1 OUT yourtablename.name1%TYPE--表中的字段
)
IS
iv_err VARCHAR2(50);
BEGIN
SELECT id INTO id
FROM yourtablename
WHERE rownum<=CC
MINUS
SELECT id INTO id
FROM yourtablename
WHERE rownum<=BB;
EXCEPTION
WHEN NO_DATA_FOUND THEN
iv_err:='没找到数据';
RETURN;
WHEN OTHERS THEN
iv_err:='查询失败'||SQLERRM;
RETURN;
END test;
BB IN NUMBER(8),
CC IN NUMBER(8),
id OUT yourtablename.id%TYPE,--表中的字段
name1 OUT yourtablename.name1%TYPE--表中的字段
)
IS
iv_err VARCHAR2(50);
BEGIN
SELECT id INTO id
FROM yourtablename
WHERE rownum<=CC
MINUS
SELECT id INTO id
FROM yourtablename
WHERE rownum<=BB;
EXCEPTION
WHEN NO_DATA_FOUND THEN
iv_err:='没找到数据';
RETURN;
WHEN OTHERS THEN
iv_err:='查询失败'||SQLERRM;
RETURN;
END test;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货