Beta Released (12.11.0.50)

Toad for Oracle - Beta
1

Beta Notes

Transactions Window

New window under Main Menu -> Session -> Transactions. Lists each connection and if it has a pending transaction or not. You can set it to auto-refresh if you want. You can commit or rollback from that window too, and it is stay-on-top but not modal, so you can leave it open if you want while you work elsewhere in Toad.

Oracle 12c R2 Support

  • DML, expressions, functions, common clauses and DROP statements.

  • CREATE FUNCTION/LIBRARY/PACKAGE/PROCEDURE/TRIGGER/TYPE statements

Code Analysis Rule 4603

Rule 4603 (“Avoid literal concatenations at runtime.”) would fire unexpectedly due to a (minor) Rule Universe issue.

PIVOT clause

Support for functions in a PIVOT clause having a WITHIN GROUP clause (undocumented feature).

Formatter

Formatting many more instances of the following statements, mainly 12c R2.
Currently about all Oracle DML and DDL statements are formatted.

  • CREATE ATTRIBUTE DIMENSION
  • ALTER AUDIT POLICY
  • CREATE CONTROLFILE
  • ALTER DATABASE
  • CREATE DATABASE
  • CREATE INMEMORY JOIN GROUP
  • CREATE LIBRARY
  • ALTER OPERATOR
  • CREATE SCHEMA
  • ALTER SESSION
  • CREATE TABLE
  • CREATE TABLESPACE
  • ALTER TRIGGER
    Code Analysis Rule 5809

Rule 5809***(“Ensure elements in the SELECT list (either columns or expressions) are qualified by a table/view name.”)* Enhancements.

Code Analysis Rule 4603

Rule 4603 (“Avoid literal concatenations at runtime.”) The rule will now flag all concatenations in a multi-concatenation.

2

I like the new Transaction window! Of course it’s a new menu item, which means most (all?) of us will need to R/C the toolbar and “Restore defaults” in order to see it.

Hey, I figured that out on my own this time! And it’s only taken me since v6 was released…

Thanks for the new window!
Rich

3

Good job, Rich!

If you don’t want to reset your toolbars, you can also right-click, choose “Customize”, go to the “Commands” tab and find it in the list (should be under either “Session” or “New”, then drag up to the toolbar or where ever you want it in the menu.

4

If anyone out there is looking for this new Transactions window, it’s been relocated, and of course would require another toolbar reset or customization. It’s now located on Toad’s main toolbar as a button which resides directly to the right of the commit/rollback buttons. Right now the glyph is just a disk but it will get updated to something better, perhaps a question mark on top of the disk.