Using linked query with views?

[Frederic]

Hi,

Here is my problem :

I'm trying to hide tables from users because table names are very technical and i'm trying to provide to users a set of views or synonyms in pl/sql developer.

I've got two problems so far.

With synonyms my users can't right-click on the synonym from the browser and chose 'query data' or 'edit data' they have to open an sql window and type their request. Aside from that they can navigate with linked query (even if the names that show up are the table names not the synonyms).

With views my users can right-click on the view and use 'query data' or 'edit data' but they can't use linked queries. Even after recreating all the constraints on the views (in DISABLE NOVALIDATE mode because it is the only mode supported with views).

Is there an option to use so that pl/sql developer takes account of my disabled constraints?

Any help would be welcome

Regards,

Frederic.

 

[Marco Kalter]

The linked query functionality is limited to tables, it will not work with views.

 

[Frederic]

Any chance that it would be extended to views in a future release?

 

[Marco Kalter]

I have added this to the list of enhancement requests.