i'm using oracle sql developer test query used in adf application's read view object. adf documentation recommends using uppercase letter begin name of bind variable. so... i've creatively named mine :bindvariable
funky part sql developer appears dislike bind variables begin upper case letter.
this query works
select * tablename id :bindvariable
this 1 not
select * tablename id :bindvariable
am correct in understanding bind variable names cannot begin upper case letter? or there else amiss here?
edit
is oracle sql developer thing? :bindvariable works fine in jdeveloper's database navigator.
thanks reading! input appreciated.
oracle sql developer: can bind variables begin upper case letter?
yes.
there no issue sql developer. have tested on version 3.2.20.10
please see screenshots:
query:
result:
no issues in sql*plus either:
sql> variable bindvariable varchar2(20) sql> exec :bindvariable := 'smith' pl/sql procedure completed. sql> select empno emp ename :bindvariable; empno ---------- 7369 sql>
Comments
Post a Comment