pl/sql accept命令解决方案

pl/sql accept命令

SQL code

set serveroutput onaccept anum number prompt 'input a number:'beginif anum > 100 then     DBMS_OUTPUT.PUT_LINE('bigger');ELSEIF anum = 100 then    DBMS_OUTPUT.PUT_LINE('same');else    DBMS_OUTPUT.PUT_LINE('smaller'); end if;end;/

SQL> @1
input a number:1
ELSEIF anum = 100 then
  *
ERROR at line 4:
ORA-06550: line 4, column 8:
PLS-00103: Encountered the symbol "ANUM" when expecting one of the following:
:= . ( @ % ;
ORA-06550: line 9, column 4:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if


[解决办法]
ELSEIF错误，应该是ELSIF

查看更多 下一篇