Toad World® Forums

Beta Released (12.8.0.3)


#1

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


#2

As you might have noticed, I’m playing around with a new format for the beta notes. I see the headings don’t seem to display very well on the actual Toad World forum post, so I’ll fix that for the next beta. Besides the usual beta notes section, we have added a new section at the bottom that will display ‘Resolved Issues’ for that build. This has been requested a few times in the past, so we’re going to try reporting them as best we can (meaning if we have time). These are external issues reported by customers (thru our Support team or possibly this forum).

Hope you enjoy the new beta, and thanks for all your valuable input.


#3

12.8 Beta Users: * Important Note *

If you installed the 12.8 Beta already, please do the following…

  1. Uninstall 12.8 Beta
  2. Download the installer again - ‘Download Beta’ or ‘Download Beta (64-bit)’ - http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/default.aspx
  3. Reinstall.

Resolved Issue: This is to fix a minor bug that was found where you could not install 12.8 beta, if you had 12.7 beta installed (even tho it has already expired).


#4

I downloaded the new version of the beta and installed it, and now I believe it is in Chinese. How do I switch it to English?


#5

Which one did you download? I just downloaded the 32-bit version and it was in English. Did you install both the MSI and MSP?

From: jcummings [mailto:bounce-jcummings@toadworld.com]

Sent: Thursday, June 25, 2015 2:01 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by jcummings

I downloaded the new version of the beta and installed it, and now I believe it is in Chinese. How do I switch it to English?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#6

I downloaded the 64-bit version and installed both the MSI and MSP using the batch file.


#7

64-bit did both MSI and MSP and yes it’s in Chinese (or so I assume - it’s not English)


#8

I just downloaded both 32 and 64 and it’s English for me. Looking.

From: droeschley_109 [mailto:bounce-droeschley_109@toadworld.com]

Sent: Thursday, June 25, 2015 2:12 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by droeschley_109

64-bit did both MSI and MSP and yes it’s in Chinese (or so I assume - it’s not English)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#9

We found the problem, I’ll let you know when the new ones are available. Sorry for the confusion.

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

Sent: Thursday, June 25, 2015 2:16 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by Dennis Paulus

I just downloaded both 32 and 64 and it’s English for me. Looking.

From: droeschley_109 [mailto:bounce-droeschley_109@toadworld.com]

Sent: Thursday, June 25, 2015 2:12 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by droeschley_109

64-bit did both MSI and MSP and yes it’s in Chinese (or so I assume - it’s not English)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#10

The updated files are there now.

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

Sent: Thursday, June 25, 2015 2:29 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by Dennis Paulus

We found the problem, I’ll let you know when the new ones are available. Sorry for the confusion.

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

Sent: Thursday, June 25, 2015 2:16 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by Dennis Paulus

I just downloaded both 32 and 64 and it’s English for me. Looking.

From: droeschley_109 [mailto:bounce-droeschley_109@toadworld.com]

Sent: Thursday, June 25, 2015 2:12 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by droeschley_109

64-bit did both MSI and MSP and yes it’s in Chinese (or so I assume - it’s not English)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#11

I’ve installed the new version and it is now in English.

Thanks!


#12

Not as cool-looking as the Chinese version, but much more usable for us single-byte US7ASCII types. :slight_smile:

Thanks much!

Rich


#13

I bet you are actually CL8MSWIN1251, and just can’t talk about it.

From: Rich J. [mailto:bounce-rjesse@toadworld.com]

Sent: Thursday, June 25, 2015 3:49 PM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by Rich J.

Not as cool-looking as the Chinese version, but much more usable for us single-byte US7ASCII types. :slight_smile:

Thanks much!

Rich

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#14

Export restrictions being what they are, how’s about a more generic and less black-helicopter-attracting AL16UTF16?


#15

Much easier to read (though much more mundane) - thanks


#16

Ni Hao!

If I right-click on the main toolbar, most of it is still in Chinese. It’s pretty easy to guess what’s what by context, but thought y’all might wanna know for completeness’ sake.

For some weird reason, I could really go for a Tsingtao right about now. Oh well, whaddya gonna do.

Thanks!

Rich


#17

Is anyone else seeing this issue? We can’t replicate this for some reason.

From: Rich J. [mailto:bounce-rjesse@toadworld.com]

Sent: Friday, June 26, 2015 9:46 AM

To: toadoraclebeta@toadworld.com

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

RE: Beta Released (12.8.0.3)

Reply by Rich J.

Ni Hao!

If I right-click on the main toolbar, most of it is still in Chinese. It’s pretty easy to guess what’s what by context, but thought y’all might wanna know for completeness’ sake.

For some weird reason, I could really go for a Tsingtao right about now. Oh well, whaddya gonna do.

Thanks!

Rich

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#18

For kicks, I did the dreaded “Restore defaults” on the RC menu of the main toolbars, and now it’s back to the usual flavor of English that I’m more accustomed to.

It was a lot of work unchecking the 4 toolbars I don’t want, but I struggled through it.

Thanks!
Rich

Disclaimer: Because you are a character doesn’t mean you have character.