Wishlist

[Erik-Berndt Scheper]

Personally, I find it very frustrating that the tree view of objects is completely collapsed when I switch from 'All objects' to 'my objects', or to 'system objects', etc.

I switch to 'my objects' whenever I find that 'all objects' contains too many entries. But now I repeatedly have to reopen the tables, views etc. of the tree.

Can you add this to the wishlist?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[DeveloperAndDba]

The feature would be very helpful for me too.

Is the wishlist visible, so i could see on what position of the wishlist / for which version this would be planned?

 

[Wojtek]

Another one.
I think that icons of objects would be more "precise". First view could let you recognize i.e. which of tables/mvs are partitioned, which are IOT, whith users are locked etc.

regards

 

[Christo Kutrovsky]

I would like not to be limited to queries involving DBA_OBJECTS only when designing my own object browser folders.

I would like to include say .. partitions ... or table statistics ...anything.

 

[Robert_G]

I've also some ideas ( )
You have made a very fine Development tool, realy i love your code editor enhancements in V6 , so...

• Wouldn't it be possible to get that fancy buttons and code outline in a testwindow?
• The Beautyfier schould also format view and table ddl.
• And last but not least (a very though one ):
  You've got this cool docu-plugin. But really cool would be having an XML Doku for all Objects.
  So you can see it's description within code-completion or while moving the mouse over an object name. Perhaps it would be possible to build these file for Oracle's standard objects from Oracle's HTML documentation.

OK, the last one would be tough, but it would make the PL/SQL Dev. the ultimate Oracle IDE.

 

[Robert_G]

Some other ideas...
One can easily test an SQL Statement with these nice buttons above your SynEdit. The PL/SQL Dev autom. generates Bind variables for all variables, but i have to change these Bind vars manually to Copy'nWaste it back into my package. Some little "Bind vars to local vars" action would be great.
Also the PL/SQL Beautifier won't break an "fetch into" List (even if it's quite long).
I think the setting used for DML (Insert) would be appropriate.

If you've got a record containing a record, the code completion won't recognize the 2nd level.

declare
  type ChildRecord is record(
    SomeVar       Integer
   ,SomethingElse VarChar2(55) );
  type MasterRecord is record(
    FirstRec      ChildRecord
   ,SecondRec     ChildRecord
   ,ThirdRec      ChildRecord );

  MyRecord MasterRecord;
begin
  MyRecord.FirstRec.

Guess what he's showing in code proposal?
-> FirstRec, SecondRec & ThirdRec
It should be SomeVar & SomethingElse.

Don't get this wrong, I really love your tool, but some of these enhancements would make it even better.

Edit: changed the wrong record declaration (I always get mixed up by PL/SQL and Delphi )

 

[Marco Kalter]

Thank you for all these suggestions, I have added them to the list.

 

[rbrooker]

any progress on getting the fabled wishlist published?

 

[Robert_G]

Yes, it would be good to know which features are "implement worthy" .

as always... thx in advance (and for this great tool)

 

[Marco Kalter]

Yes, we'll use SupportWizard (http://www.supportwizard.com ) for on-line helpdesk functionality in the near future.

 

[schatwin]

I'd really prefer that the tree in the browser could be switched to group by schema name first, then by object type. (currently it's objct type only)

 

[Marco Kalter]

Note that you can open the "Users" folder to view objects by owner > type.

 

[@charles@]

Will you provide variable highlighter function in the near future?
I tried FindAll plug-in. It works fine, but the extra window is not that handy. Is it possible to highlight the matching text directly in the searching panel? That will be very helpful!
Thanks

 

[ScottMattes]

FindAll is my plugin.

If there is an API link to get to PLSD's hilighter then the answer is YES.

Marco?

 

[Marco Kalter]

What do you mean by "highlighter"?

 

[ScottMattes]

syntax hilighting is what I think he means.

 

[Stew Stryker]

While we're wishing...

An enhancement to the browser icon for Database Links. I'd like to see a different icon for my personal links to distinguish from the public database links. Otherwise I have to open each one to find my private links when I change my password on the linked database.

Thanks,

 

[Marco Kalter]

Okay. Note that you can create a separate query-based folder for private and public database links.

 

[orca777]

Originally posted by Wojtek:
Another one.
I think that icons of objects would be more "precise". First view could let you recognize i.e. which of tables/mvs are partitioned, which are IOT, whith users are locked etc.

regards

totally agree!!
Carl

 

[@charles@]

OK, let me clarify the variable highlighter.
With the help of a variable highlighter, all occurrences of the same variable in the scope will be highlighted when cursor pointing to any of them. This will help developer to find the definition and all the usages of a variable easily.
You may take JDeveloper's variable highlighter as an example. When you point to a variable in a Java class, it will highlight all valid usages of that variable by setting the background color to YELLOW for an instance variable. Or, it will set variables

 

[Ivan C.]

charles (and Marco),

This would be a very, very cool feature. I'm surprised no one (including me) requested it before.
I realized how badly I (or anyone else) would need something like this only after reading this post. Just imagine being able to see every place where a variable is declared, set or used (within the scope, of course) at the same time...

I can't wait to have a feature like this.

Please, Marco!

 

[Marco Kalter]

That would indeed be very cool, and it would probably even be useful! We'll look into it.

 

[ScottMattes]

That is why I wrote FindAll. The hilighting of the string would be nice though

 

[@charles@]

Woo! Let me give more challenge to Marco: lots of IDEs have block indicator. Say, when you put cursor on the starting parenthesis, both starting and the corresponding ending parenthesis will be highlighted. It will be very helpful to highlight the following block delimiters in PL/SQL:
BEGIN, EXCEPTION, END
IF, ELSIF, END IF
FOR, END LOOP
...
To make a sophisticated variable highlighter, you got to know the block. As a by-product, I would hope you can provide this feature as will.
Charles

 

[ScottMattes]

this is already present in version 6