是用 & 不知道楼主是否是下面的意思(转贴)SQL> create table a(id integer,name varchar2(10));表已创建。SQL> begin 2 insert into a values(&id,'&name'); 3 end; 4 / 输入 id 的值: 1 输入 name 的值: test 原值 2: insert into a values(&id,'&name'); 新值 2: insert into a values(1,'test');PL/SQL 过程已成功完成。SQL> select * from a; ID NAME ---------- ---------- 1 test SQL>
ACCEPT ------Reads a line of input and stores it in a given user variable.ACC[EPT] variable [NUM[BER] | CHAR | DATE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text | NOPR[OMPT]] [HIDE]
2 insert into a values(&id,'&name');
3 end;
4 /
输入 id 的值: 1
输入 name 的值: test
原值 2: insert into a values(&id,'&name');
新值 2: insert into a values(1,'test');PL/SQL 过程已成功完成。SQL> select * from a; ID NAME
---------- ----------
1 test
SQL>
------Reads a line of input and stores it in a given user variable.ACC[EPT] variable [NUM[BER] | CHAR | DATE] [FOR[MAT] format]
[DEF[AULT] default] [PROMPT text | NOPR[OMPT]] [HIDE]