I'm using SQL Developer 184.108.40.206.07 ... and whenever i use something like ...
variable myVar Number; execute :myVar := 10;
A query like ...
select :myVar "myVar" from dual;
Gives me the result ...
myVar ----- -- that is "null", as I don't have a null replacement ;-)
What I'm doing wrong? Any advice (besides using VarChar2)?
Thanks in advance