No, due to the Oracle SQL optimizer will treat variables and hardcoded literals in different ways.
For example;
Select * from TableA where A.key<:var
You should not change the :var to ‘ABC’ like this:
Select * from TableA where A.key<’ABC’
No, due to the Oracle SQL optimizer will treat variables and hardcoded literals in different ways.
For example;
Select * from TableA where A.key<:var
You should not change the :var to ‘ABC’ like this:
Select * from TableA where A.key<’ABC’