Beta Notes
Editor Styles
“Camel Case” character case option added for editor styles. AKA init caps, title case
Packages in Schema Browser
The query has been changed, so the list of packages should load faster now for some users.
SQL Recall
Organization
-
Two types, Recent and Saved. Named and Personal of old are now “Saved.”
-
Saved statements are assigned to a category and optionally given a name. Name is unique within a category.
-
SQL Recall stored in XML format.
Display
-
Statements can be grouped by Schema, Database, Schema (by Database), Last Executed (Recent only), Category (Saved only), and Name (Saved only).
-
Show more or less lines of SQL by using CTRL+"+" or CTRL+"-"
-
A “Flip Form Layout” feature will flip the tree/memo orientation from vertical to horizontal and vice versa.
Management
-
Recent statements are read-only and can be dragged to the “Saved” tab.
-
The properties dialog (F2) can be used to modify one or many selected Saved statements
-
Changes to the memo will update the selected Saved statement. The memo is read-only if multiple statements are selected.
-
Copy/Paste supported including pasting of plain text.
Filtering
-
Filter support added (CTRL+F)
-
Filters can be named for later use. By default all filters are ad hoc, but Toad will remember the most recently used filters.
-
An “Edit Filters” dialog is used to modify saved filters.
-
Suggested filters are available using properties found in your statements.
Import/Export
-
Import from the old data file format (.dat) or the new (.xml).
-
Export (CTRL+S) has 4 source options: All, All Recent, All Saved, and Selected. There are 3 destination options: Data file, Single File, and Individual Files. Individual Files will create a new file for each Saved Category and one file
for all Recent.
Ideas Addressed
http://www.toadworld.com/products/toad-for-oracle/i/editor/7d324c9c-5c5c-4286-bcec-c5d5b273f7fa.aspx
http://www.toadworld.com/products/toad-for-oracle/i/importexport/sql_export_of_named_sql.aspx
http://www.toadworld.com/products/toad-for-oracle/i/editor/3d984225-1c82-40b5-8270-6ae9c0613af7.aspx
Session Browser Toolbar Cleanup
-
The “Filter” dropdown and button (which was above the toolbars, and only affected the “Sessions” tab) has been combined with the “Filter” button on the “Sessions” tab.
-
The refresh options have been moved to a dropdown on the refresh button.
Trace File Browser -
A “Line #” column has been added to each grid where it makes sense, so you will know which line in the file provided each bit of information. In addition, you can rt-click and choose “Display file contents where data of selected row was found”. This will
display a dialog with that line of data, plus 1000 lines before and after. -
New columns on the “Statement” grid: “Cursor #”, “Exec Time (Avg)”, “Exec Time (Max)”
-
A “Select visible columns” dialog has replaced the rt-click option on the column header to hide/show columns.
-
New charting options: “Exec Time (Avg)” and “Exec Time (Max)”
Resolved Issues
Issue
ID
GSS: Tables are created before sequences, should be the other way around
117968
Code Templates: Import and Export removed
117967
Auto connections not made in a consistent order
117964
Editor: IC buttons returns in this case.
117950
Code Templates: Cursor being placed on first line, instead of last line
117949
Import Table Data: ODBC changing year in dates to 2020
117911
Unable to run statspack report on a selected snapshot pair when using direct connection mode
117405
Toad: Looks like it is adding a LF to CR, when there should only be a CR when importing.
107281
