可以,用set define :scott@ORA11GR2> select &a from dual; Enter value for a: 1 old 1: select &a from dual new 1: select 1 from dual 1 ---------- 1scott@ORA11GR2> set define : scott@ORA11GR2> select :a from dual; Enter value for a: 1 old 1: select :a from dual new 1: select 1 from dual 1 ---------- 1
Enter value for a: 1
old 1: select &a from dual
new 1: select 1 from dual 1
----------
1scott@ORA11GR2> set define :
scott@ORA11GR2> select :a from dual;
Enter value for a: 1
old 1: select :a from dual
new 1: select 1 from dual 1
----------
1
你这个只在Command Window有用啊SQL Window该如何做呢?