Experiences with ClearSQL PlugIn for PL/SQL Developer?

[Stew Stryker]

Has anyone tried this utility out yet?

Given that Developer already includes a basic code Beautifier and the Code Contents window already does a great job of navigation, does ClearSQL add enough value?

The debugger/trace tool in ClearSQL looked interesting but otherwise I don't see much that isn't already in Developer.

Any other opinions?

Thanks,

Stew

 

[ScottMattes]

I don't see it listed on the Add-ons page.

 

[Stew Stryker]

It's commercial.

I found a link to it in this forum (I think?). Here it is.

http://www.clearsql.com/index.html

Here's the feature overview from their site (no promises from me!):

ClearSQL contains several standard structures:

* A language parser, designed specifically to read the Oracle PL/SQL language, reports on incorrect syntax, and builds internal data structures representing the program.
* A symbol table, used to keep track of names and types of language entities such as variable and functions, and handling language scoping rules.
* A prettyprinter, which can regenerate the code from the program representation data structures.
This provides formatted, readable regenerated source code.
* Code profiler module analyzes the complexity of your programs by giving report on the level of nesting of IFs, LOOPs, etc.
* Code review module catches over 50 common coding mistakes and gives suggestion as to coding best practice.
* A code generation component, which uses the program representation data structures and the results of the analyzers to generate a custom modified code. ( * custom build only )

Stew

 

[mike]

I used it during the free trial for a month. It was an earlier version than they have now.

They have 2 versions. One is stand alone and one is a plug-in for PL/SQL Developer. I couldn't get the stand alone version to work for me.

I liked the Code profiler module and the Code review module. That seemed to be the only things PL/SQL Developer didn't have at the time. The code review module is kind of like having more hints in PL/SQL Developer. I didn't notice the code generation component so maybe that's something. I don't know.

It basically suggested to break up complex code and don't do stupid stuff. It gave some nice graphs.

I didn't buy it since it seemed cheaper to just break up complex code on my own and not do stupid stuff.

The product does what it says though and it was kind of fun to see what it suggested.

I'm kind of curious if others found something I missed that would make it more worth it.

Mike