Oracle 动态变量初始化中的问题。

DECLARE
  a INTEGER;
BEGIN
  a :=  &a;
  DBMS_OUTPUT.PUT_LINE('a = ' || TO_CHAR(a));
END;
/

Error:

SQL Worksheet
ClearView SessionResetSaveRun


1
2
3
4
5
6
7
DECLARE
  a INTEGER;
BEGIN
  a :=  &a;
  DBMS_OUTPUT.PUT_LINE('a = ' || TO_CHAR(a));
END;
/

ORA-06550: line 4, column 9:
PLS-00103: Encountered the symbol "&" when expecting one of the following:

   ( - + case mod new not null 
    
   continue avg count current exists max min prior sql stddev
   sum variance execute forall merge time timestamp interval
   date 
     pipe
   

如何从键盘获取输入值？？
 

复制

set define on
复制

set define off
DECLARE
  a INTEGER;
BEGIN
  a := &a;
  DBMS_OUTPUT.PUT_LINE('a = ' || TO_CHAR(a));
END;
/

Error report -
ORA-06550: line 4, column 8:
PLS-00103: Encountered the symbol "&" when expecting one of the following:
...
复制