Wish list 2

[Wojtek]

I used to use SQL Navigator, and maybe this post comes out of my habit to this tool. I think that it would be a good idea to put on object tree (I don't know how to name it - its on the left of the main window) all available types of objects. Ie. I can't see there indexes, snapshots, constraints and so on... ordered by name.
More over I don't know how to DDL objects in PL/SQL Dev - maybe it would be niece to have it under right button of the mouse - clicking on object in mantioned object tree?


Regards
Wojtek

 

[Marco Kalter]

Do you mean that you would like to see indexes, constraints, and other sub-objects in the root of the Object Browser?

To view the DDL of an object, you can either:

1. Drag & drop it into an editor and select "DDL" from the popup menu.

or

2. Right click on the object, select "View", and press the "SQL" button if the object is not a Program Unit or View.

 

[Milan Martak]

Originally posted by Wojtek:
I used to use SQL Navigator, and maybe this post comes out of my habit to this tool. I think that it would be a good idea to put on object tree (I don't know how to name it - its on the left of the main window) all available types of objects. Ie. I can't see there indexes, snapshots, constraints and so on... ordered by name.

Well, yes - i recently switched from SQL Navigator too. I do not suffer too much from not having this feature, but sometimes it remember how it was...
What about customizable folder? Meaning that i can define the object(s) for the folder (as for instance materialized views, etc.) on my own. And - indeed - we may ask Joachim Rupik to enhance a little bit the Browser Extender so we can call another program/plugin as an Action and that would be it
M.

 

[Wojtek]

Originally posted by Marco Kalter:
Do you mean that you would like to see indexes, constraints, and other sub-objects in the root of the Object Browser?

Yes exactly ! Especialy Snapshots ! How to see them? These aren't tables.

To view the DDL of an object, you can either:

1. Drag & drop it into an editor and select "DDL" from the popup menu.

or

2. Right click on the object, select "View", and press the "SQL" button if the object is not a Program Unit or View.

Ok fine, but what about partitioned tables/indexes. Ok I can see DDL for them but as a "normal" not partitioned tables. And the same about snapshots?
Regards
Wojtek

 

[Marco Kalter]

Ok fine, but what about partitioned tables/indexes. Ok I can see DDL for them but as a "normal" not partitioned tables. And the same about snapshots?

Partitioned tables and materialized views will be supported in 6.0.

What about customizable folder? Meaning that i can define the object(s) for the folder (as for instance materialized views, etc.) on my own. And - indeed - we may ask Joachim Rupik to enhance a little bit the Browser Extender so we can call another program/plugin as an Action and that would be it

User-defined folders are added in 6.0 as well. You can define you own folder queries, or manually add specific objects to a folder.

 

[Wojtek]

Is there any way to launch new SQL window (and others windows) by some short cuts (i.e: Ctrl + N). It would by very halpfull.
Regards
W

 

[patch]

You can assign your own hotkeys to these actions.
I for instance have CTRL-ALT-S for new sql window.
Go to Tools-Preferences
Select the 'Key configuration' tab
Look for the File / New / and add the desired hotkey.

Regards,
Patrick

 

[Wojtek]

Originally posted by patch:
You can assign your own hotkeys to these actions.
I for instance have CTRL-ALT-S for new sql window.
Go to Tools-Preferences
Select the 'Key configuration' tab
Look for the File / New / and add the desired hotkey.

Regards,
Patrick

Am I blind or what...?

Thanx
Wojtek

 

[Wojtek]

It seems to refresh button "refresh data" doesn't work. The same with context menu lauched by right click.
I renamed table, recompile package (from other session of PLSQL Dev) and after refresh there is no change.

W

 

[Marco Kalter]

The Refresh function only works on the currently selected object. Maybe this causes confusion?

 

[Anthony Harper]

Marco,
With regards to the object browser pane, I'm not sure that I would isolate partitioned tables, but I would like to view the partitions in the subtree under the table...actually a storage branch would be great...where you could view the segments, partitions, or other aspects to table storage (including segment sizing and other detailed sizing aspects...this same storage analysis could be placed under each index or partition)...if would be an excellent feature if you could alter a partition right there on the object browser without editing the table. Even in 6.0current it isnt possible to alter the partitions using the gui in plsql developer without recreating the table. (much like the ability to disable a foreign key)...Alter index or table switches (logging/no logging) would be another great feature.

Thanks, (sorry about chaining so many ideas together, my main concern is to make management of the design for large databases easier with plsql developer)
Regards,
Anthony Harper

Originally posted by Marco Kalter:
Ok fine, but what about partitioned tables/indexes. Ok I can see DDL for them but as a "normal" not partitioned tables. And the same about snapshots?

Partitioned tables and materialized views will be supported in 6.0.