Hi there,
Thanx for Pl/Sql Devloper. I found it very very usefull. I'm DBA using it mainly to optimize SQL queries and would be great to have data type hint for pointing (by mouse or cursor) column of where clausule.
What for? As the DBA usually i don't remember what type of value is expected in where condition, so I have to spent "much" time finding that.
Folowing example shows the point when hint is usefull:
select a.col1
from Tab1 a
where
a.col1 = :v1
To execute the query i have to know what value i should put for :v1. Is it date, number or varchar or something else?
Do you think would it be usefull feature?
Regards,
Roman
Thanx for Pl/Sql Devloper. I found it very very usefull. I'm DBA using it mainly to optimize SQL queries and would be great to have data type hint for pointing (by mouse or cursor) column of where clausule.
What for? As the DBA usually i don't remember what type of value is expected in where condition, so I have to spent "much" time finding that.
Folowing example shows the point when hint is usefull:
select a.col1
from Tab1 a
where
a.col1 = :v1
To execute the query i have to know what value i should put for :v1. Is it date, number or varchar or something else?
Do you think would it be usefull feature?
Regards,
Roman