"Query Data" on Views

[Dave Man]

Hi, I'm using PL/SQL Developer 5.1.0.654. I have long wished for a feature where I could click "Query Data" on Views just like I can for Tables. Is there a reason this isn't available, or am I just looking in the wrong place?

 

[patch]

IMHO the option to query the data should just be available in the context menu. In my version 5th option from the bottom.

Hope this helps,
Patrick

 

[Dave Man]

Oops, I was wrong in my complaint. What I really want is Query Data on Synonyms not Views. Don't know how I made that mistake.

Is there a way to add Query Data to the right-click menu for Synonyms?

-Dave

 

[Christo Kutrovsky]

Yes, with the browser extender you can.
(or at least should be able to)

 

[Joachim Rupik]

Yes the Browser extender allows adding a popup menu to the "synonyms folder", but unfortunately plug-in does not know for what type of object the synonym is. Query data could not be done for all synonyms .

Greetings,
Joachim Rupik

 

[aotte]

Originally posted by jrupik:
Yes the Browser extender allows adding a popup menu to the "synonyms folder", but unfortunately plug-in does not know for what type of object the synonym is. Query data could not be done for all synonyms .

Hmmm, maybe a possible new feature could be that synonyms of the appropriate type (table/view/procedure/etc) are added to the list of that type, with a slightly different icon, indicating it is a synonym, in addition to be listed as synonyms?

That would of course extend the background queries, getting the additional dictionary data. As people commonly working with a small network link won't like that, it would have to be an optional feature.

I was thinking about the hardships that a small network link brings and thought it might be a good idea to have a single toggle on the preferences: broadband/dial-up or something similar, which let's you choose between the full blown range of the dictionary look-up availability, and the restricted range, which would than cause multiple small delays, because not all data is retrieved in one go. That way people can switch between working in the office and working from home easily. Just an idea.