pl/sql accept命令
SQL code
set serveroutput on
accept anum number prompt 'input a number:'
begin
if 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