Just a few thoughts about what I intend to do next with SQLTools++:
First I need to do a bit more cleanup to the items installed by the Installer. In particular the "history" file has not been updated yet and the link to the Homepage added to the Explorer menu still points to the old homepage (the link in the application has already been updated). Just cosmetics, so when I find some time this will be updated, too.
Next I'll try to finish the 9i emulation of the 10g DBMS_XPLAN.DISPLAY_CURSOR functionality. The query to V$SQL_PLAN_STATISTICS_ALL is already done, and I'm currently working on a big anonymous PL/SQL block which is supposed to parse and format the query output similar to the DISPLAY_CURSOR function. This PL/SQL block will then be executed by SQLTools++ to get the output to display. Probably the PL/SQL block will reside in a separate text file so you will able to change and/or extend it if you are willing to.
Next thing on my list would be the interface to DBMS_METADATA. This is pretty straightforward and I hope that it won't take too much effort to get it in.
May be in parallel I'm going to revisit the "Online visual match" issue again, but that's definitely low priority, as the "Find Matching Brace" functionality works very well for me.
Ah, yes, and by the way: Now that I've released SQLTools++ to public I expect some bugs will come up which need to be fixed...
Blog Archive
About Me
- Randolf Geist
- I live close to Heidelberg, Germany, and spend most of my time working as independent consultant specialised in helping my customers getting the most out of the Oracle database. I spend my free time with my family, and if time allows for it, I enjoy myself pursuing my hobbies.
7 comments:
Hi,
A very good work!
There will be an ER Diagram reverse function?
Bye
Giuseppe Mosca
Giuseppe,
this is not really a functionality I was thinking about... Sounds to me far too complex. The only SQL tool I'm aware of that offers such a functionality is TOAD from Quest Software.
Regards,
Randolf
Great thanks for your (and original dev) work.
I'm missing the full shema export/import utility..
DDL is no enough.
Just basic interface to imp/exp.
(just yesterday i had to rescue (using Toad or commandline) couple of them from some godforsaken NT box.. on 5'th attempt it even did'nt bluesceened on me! ;P )
Thanx.
HeadLess
HeadLess,
unfortunately I don't get exactly what you are missing.
What is in your opinion a full schema export/import utility?
I mean, that's something that exp/imp (or nowadays expdp/impdp) offer, what exactly do you want the tool to do then?
Call imp/exp using the appropriate command line options?
Regards,
Randolf
This seems to be a very good work,
especially the 1 & 2 topics.
Rem: Anonymous PL/SQL Blocks containing blank lines meets a new problem ;o( they have to be fully selected to be ran.
For next release I would vote for the Edit Data feature !
Would it be possible to propose a kind of flat files export/import feature like thoses found at
http://www.withdata.com/oracmd.html
or at
http://www.volny.cz/iprenosil/interbase/fsql-examples.htm
Regards
PAscal
Pascal,
thanks for your valuable comments.
Yes, you are right, the current behaviour poses a problem with anonymous PL/SQL blocks that contain blank lines.
I have a lot of ideas/enhancements in the queue but currently I'm just too busy in my job so that things are currently going very, very slowly.
I hope that I'll find some more time in the future to spend on this tool. Next thing I'm actually planning to do is to release a bug fix version that fixes the most annoying bugs that I've encountered so far, and hopefully some minor improvements. But this definitely will take some time until completed.
Oups I forgot plloader:
a C++ advanced oracle loader allowing arbitrary SQL and PL/SQL to be run as data is loaded available at http://sourceforge.net/projects/plloader
Regards,
PAscal
Post a Comment