Another wish (improving SQL Window)

ToRo

Member
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
 
One addition to above post.
It would be cool to access via context menu properties (to see the statistisc) for the columns in where clausule.
 
I have added this to the list of enhancement requests.

------------------
Marco Kalter
Allround Automations
 
Back
Top