Support for Composite Partitioning

[BWendling]

Hi,

is there a plan to support composite partitioning (subpartitioning) such as Range/List?

 

[jto]

Hello,
I've been evaluating PL/SQL Developer last 2 days (28 days of evaluation left and I have to agree that partitioning support is important for users of Oracle Enterprise edition. It's one of the reasons why I'll have to keep my SQL Navigator no matter how much I like your program (which I intend to buy, btw .
And because I write this post, here are some more observations of mine:

Small "visual" bug
- line numbers don't fit into lines in Editor windows with Lucinda console size 8 as my editor font

Java related bug?
- I tried to recompile Java class stored in the database and got ORA-04043 object ... does not exist. The same class was recompiled without problems using alter java source "..." compile; in command window.
The error message contained the name of the class in uppercase, maybe that can be the problem?

And request for some enhancements - could you, please, consider to extend the functionality with the following?
- search for previous/next occurence of a word (e.g. variable, function name) in Editor window with a key shortcut as it is for example in PSpad (www.pspad.com/). There you can use Ctrl+Shift+Up/Down arrow to find previous/next occurence of the word you have cursor at
- add more syntax highlighting groups, having the basic 5 and 1 custom is kind of limiting if one uses Syntax HighLighting plugin
e.g. I'd like to have different highlighting for tables and different for my constants, can't have it with just one custom group
- add support for partitioned tables in Browser - show them with different icons, add information about partitioning...
- add "Extract DDL" option into right click menu in Browser, using Tools/"Export user objects" is an option but kinda long one and Duplicate can be used only with single selection not for multiple objects
- add an option to have the "Sort content" button in package editor ON by default?
- show the default double click option in bold in the right click menu in Browser window

That's it so far. Really good job, I like the program a lot. I've tested it already 2 years ago or so but didn't like it, it's a completly different story now

best regards, your future customer

 

[Marco Kalter]

is there a plan to support composite partitioning (subpartitioning) such as Range/List?

This is on the list of enhancement requests.

- I tried to recompile Java class stored in the database and got ORA-04043 object ... does not exist.

Did you use a lower/mixed case identifier with quotes?

And request for some enhancements

I have added them to the list. One remark:

- search for previous/next occurence of a word (e.g. variable, function name) in Editor window with a key shortcut as it is for example in PSpad (www.pspad.com/).

Note that you can already use the "Repeat last find" function (Ctrl-L).

 

[jto]

- I tried to recompile Java class stored in the database and got ORA-04043 object ... does not exist.

Did you use a lower/mixed case identifier with quotes?

I used the Recompile option from right click menu in Browser window so I didn't use any quotes. The name of the class contains both lower and upper case characters.

 

[aotte]

Originally posted by jto:
- add "Extract DDL" option into right click menu in Browser, using Tools/"Export user objects" is an option but kinda long one and Duplicate can be used only with single selection not for multiple objects

I always select the tables I want in the browser, and then drag them into my editing window of choice and select DDL from the pop-up menu. Does that work for you?

 

[jto]

Originally posted by aotte:

Originally posted by jto:
- add "Extract DDL" option into right click menu in Browser, using Tools/"Export user objects" is an option but kinda long one and Duplicate can be used only with single selection not for multiple objects

I always select the tables I want in the browser, and then drag them into my editing window of choice and select DDL from the pop-up menu. Does that work for you?

It does! Thanks for the tip, I didn't think about this possibility. Simple and great...