CREATE OR REPLACE PROCEDURE AAA
AS
BEGIN
IF (SELECT BPRICE FROM BOOKS WHERE BID = 1) = 0 THEN
.....
END IF;
END;
说是"SELECT"这句出错了,错误信息:
错误:PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
AS
BEGIN
IF (SELECT BPRICE FROM BOOKS WHERE BID = 1) = 0 THEN
.....
END IF;
END;
说是"SELECT"这句出错了,错误信息:
错误:PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
select 语句不能作为if的查询判断条件。
比如temp
SELECT BPRICE into temp FROM BOOKS WHERE BID = 1
if temp=0
AS
TEMP VARCHAR2(10);
RESULT NUMBER(10);
BEGIN
TEMP :="SELECT BPRICE INTO RESULT FROM BOOKS WHERE BID = 1";
IF (RESULT) = 0 THEN
.....
END IF;
END;
CREATE OR REPLACE PROCEDURE AAA
AS
v_temp NUMBER(1, 0) := 0;
BEGIN
BEGIN
SELECT 1 INTO v_temp
FROM DUAL
WHERE ( SELECT BPRICE
FROM table_a
WHERE a = 1 ) = 0;
EXCEPTION
WHEN OTHERS THEN
NULL;
END; IF v_temp = 1 THEN
DBMS_OUTPUT.PUT_LINE('sdfds'); END IF;END;