Beta Released (12.1.0.3)

Toad for Oracle - Beta
1

12c Pluggable Database Support:

The database browser’s Pluggable Database tab (visible when a container database is selected in the LHS) now supports: Create pluggable database from seed, clone, or XML File Drop pluggable database Unplug pluggable database Analyze all objects: Added the ability to use DBMS_STATS.GET_PREFS and DBMS_STATS.SET_PREFS (available on Oracle versions 11g and newer). These give you the ability to define and use preferences for different dbms_stats parameters at a database, schema, or table level.

Editor - Refactoring:

Some general tweaks to the rt-click refactoring menu item to better organize and label the actions.

“Convert to Oracle Join Syntax” added - Will convert a query using ANSI syntax to Oracle syntax.

“Remove Subqueries Using ANSI Join Syntax” and “Remove Subqueries Using Oracle Join Syntax” added - Statements having subqueries are rewritten to use join syntax instead.

2

Looks like we had a formatting problem. That first one was a little confusing with all the words running together. It should have been:

12c Pluggable Database Support:

The database browser’s Pluggable Database tab (visible when a container database is selected in the LHS) now supports:

·
Create pluggable database from seed, clone, or XML File

·
Drop pluggable database

·
Unplug pluggable database

Analyze all objects

Added the ability to use DBMS_STATS.GET_PREFS and DBMS_STATS.SET_PREFS (available on Oracle versions 11g and newer). These give you the ability to define and use preferences for different
dbms_stats parameters at a database, schema, or table level.

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Thursday, July 18, 2013 2:20 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Beta Released (12.1.0.3)

12c Pluggable Database Support:

The database browser’s Pluggable Database tab (visible when a container database is selected in the LHS) now supports: Create pluggable database from seed, clone, or XML File Drop pluggable
database Unplug pluggable database Analyze all objects: Added the ability to use DBMS_STATS.GET_PREFS and DBMS_STATS.SET_PREFS (available on Oracle versions 11g and newer). These give you the ability to define and use preferences for different dbms_stats parameters
at a database, schema, or table level.

Editor - Refactoring:

Some general tweaks to the rt-click refactoring menu item to better organize and label the actions.

“Convert to Oracle Join Syntax” added - Will convert a query using ANSI syntax to Oracle syntax.

“Remove Subqueries Using ANSI Join Syntax” and “Remove Subqueries Using Oracle Join Syntax” added - Statements having subqueries are rewritten to use join syntax instead.