日期:2014-05-17  浏览次数:20795 次

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