little9933
Member²
Does the PL/SQL developer can support the SQL statments with parameter ?
Debug Sql statment in PL/SQL?
- Thread starter little9933
- Start date
ScottMattes
Member³
YES!
In a SQL Window enter
select *
from all_objects
where object_name = '&obj_name'
and press F8 to execute
In a SQL Window enter
select *
from all_objects
where object_name = '&obj_name'
and press F8 to execute
Also, if you have bind variables like this
select *
from all_objects
where object_name =
bj_name
You can right click on the select statement and select test from the pop-up menu. A test window will show up. Press F8 to execute and a SQL tab will have the results.
Since we are on the topic, if you have a query with an ampersand in a literal, it always pops up a window asking for what to put in the "variable" even though it's not intended to be a variable.
It would be nice to have a button on the side to turn substitution variables on and off. Maybe there's another way that I don't know of?
Thanks,
Mike
select *
from all_objects
where object_name =
bj_nameYou can right click on the select statement and select test from the pop-up menu. A test window will show up. Press F8 to execute and a SQL tab will have the results.
Since we are on the topic, if you have a query with an ampersand in a literal, it always pops up a window asking for what to put in the "variable" even though it's not intended to be a variable.
It would be nice to have a button on the side to turn substitution variables on and off. Maybe there's another way that I don't know of?
Thanks,
Mike
Similar threads
- Discussion
