请问在pl/sql developer里,能否改变参数的符号?
比如,PL/SQL developer里,要传递参数,需要这样写
select &a from dual
有没有地方设置,让它变为
select :a from dual
跟Toad一样?
------解决方案--------------------可以,用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
scott@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该如何做呢?
------解决方案--------------------顶下吧,看有没高手亮相