SQL> create or replace procedure test
2 as
3 a integer;
4 begin
5 a:=to_number(&b);
6 dbms_output.put_line(a);
7 end;
8 /
Enter value for b: 3
old 5: a:=to_number(&b);
new 5: a:=to_number(3);Procedure created.SQL> exec test
3PL/SQL procedure successfully completed.
2 as
3 a integer;
4 begin
5 a:=to_number(&b);
6 dbms_output.put_line(a);
7 end;
8 /
Enter value for b: 3
old 5: a:=to_number(&b);
new 5: a:=to_number(3);Procedure created.SQL> exec test
3PL/SQL procedure successfully completed.
在sql/plus中可用 accept ...输入数据,
但,写成过程时好象不行的. accept会说语法错...
留意....