Toad Week (Toad Strong!) - Hi, tried this yet?

[ToadThumbsUp.png]
Hi there,
Last week’s post went to junk folders, so this week I greatly reduced the number of links.
Toad Week, Toad Strong!
Weekly tips to strengthen your use of Toad for Oracle
Power Users
Who are power users? You are!
Thanks, Norm! We do think this is useful, and the Beta list might not have seen it.

Morning all,



There have been a number of "problems" in the past reported here about inserting (or updating) data which contains an ampersand. The following might be useful?



SQL> create table amp(a varchar2(100));

Table created.



SQL> insert into amp values ('Us & Them');

Enter value for them: XXXX

1 row created.



SQL> insert into amp values ('Us ' || '&' || ' Them');

1 row created.



SQL> insert into amp values ('Us &' || ' Them');

1 row created.



SQL> select * from amp;



A

---------

Us XXXX

Us & Them

Us & Them



It appears that you only get prompted for a substitution if the ampersand is in the middle of the string. If it is on its own - as per the second example, or at the end of a/the string - example 3 - then it is not considered a substitution prompt and is inserted or updated as is.



I know you can change the define character, but it's always a good thing to have more than one way to skin a cat, proverbial or otherwise!



Works for update statements as well:



SQL> update amp set a = 'Us '||'&'||' Them'

   2  where a = 'Us XXXX';

1 row updated.



SQL> select * from amp;



A

---------

Us & Them

Us & Them

Us & Them



And selects/Deletes:



SQL> select a from amp

   2  where a =  'Us '||'&'||' Them';



A

---------

Us & Them

Us & Them

Us & Them



SQL> delete from amp

   2  where a =   'Us '||'&'||' Them';



3 rows deleted.



--

Cheers,

Norm. [TeamT]


Dev Team
Tried Search KB?
In 11.5, get immediate Knowledge Base wisdom from our award-winning Support team.
Hint: Both the KB and online Help have great content about the completely overhauled Query Builder (11.5).
[SearchKB.png]

Now you can close Toad!
The new Workspaces in 11.5 save your connections and more.
This comment from a Beta user says it all (this is available to all users in 11.5):

“Love the new workspace concept. I've got two connections and half a dozen files and database objects open and they come back right where I left them. Cool!”

Excerpt from 11.5 New in This Release:

  *   Click 'Save current Workspace' [cid:[email protected]]  in the Workspace toolbar (part of the main toolbar) to save and name your current configuration of Toad windows and connections.
[cid:[email protected]]
When you open Toad, the Workspace toolbar indicates, "No Workspace selected." The toolbar displays the Workspace in use, and provides the list of available Workspaces, and buttons to save and remove Workspaces.
There is a starter Workspace named "Default Workspace" which can be used instead of creating your own. It is initially empty (that is, contains no windows or connections). This Workspace is the only one which cannot be deleted.

  *   See "Using Workspaces" in the online help for more information.
Note: Changes to your Workspace configuration are only saved when you click 'Save current Workspace' [cid:[email protected]]  in the Workspace toolbar.
Beta users, want more company?
Invite your colleagues.
To join our Beta users, go to http://toadfororacle.com/beta.jspa
New Toadies
[CoolToadFuture.jpg]
You were new once, too, and look at you now
Here’s a Support Solution with video on how to migrate settings from an older version of Toad<https://support.quest.com/Search/SolutionDetail.aspx?id=SOL42583&category=Solutions&SKB=1&product=Toad%20for%20Oracle>.
This week’s tweet (video from PM)
Do you tweet yet? (I know, I know, but you can get good info.)
Tweet
Donna Buskirk ‏@Toadwriter<https://twitter.com/#!/Toadwriter>
What's New for Developers in Toad for Oracle 11.5:http://youtu.be/jzX-tHk9aJw<http://t.co/zQNzynnB> via @youtube<https://twitter.com/#!/youtube>

Follow me, I’ll follow you. ;)
… @ToadWriter.



Support Solution
F9 to Execute SOL65401
Title
When using F9 or Shift+F9 to execute a select query, during the first execution, no rows is returned, and upon moving the cursor to another line, and re-execute the query, result is returned.
Problem Description
The syntax style is set to change string to uppercase. When using F9 or Shift+F9 to execute a select query which has a where clause value of string in CAPS, during the first execution, no rows is returned, and upon moving the cursor to another line, and re-execute the query, result is returned.  The data is in upper case.
Cause
Basically, because the capitalization is set for 'strings', the way the editor works is that even though on the screen it appears to be upper case, behind the scenes it is actually still lower case. Once the cursor is moved to a different line, then it will actually convert the lower case to uppercase permanently (just like the screen displays).
Resolution
Move the cursor up or down a line in the query.  Kindly share this information on the editor's behavior in regards to String capitalization with colleagues who are affected. Also our recommendation is as best practice to set the string to uppercase using Oracle's 'upper' function, or to actually type the string out in CAPS. Let me know whether this clarifies.
Additional Information
At this time, there is nothing that can be done, as this is found to be a known issue with the backend editor processor.
Product
Toad for Oracle 10.5.1

Favorite line from the lists

“I started using in 1999 in the 6.3 days and it was amazing then, but that was chump change compared to what we can do these days. You guys and gals are just amazing, both the Quest folks and all the amazingly smart people on this list.”

[email.png]


“Tipsy Toad”
Share your favorite tips.
Email me<mailto:[email protected]?subject=Tipsy%20Toad> with “Tipsy Toad” in the subject line.
(Wouldn’t you know it, Tipsy Toad is the name of a bar.)


Still Reading?
Guess who on the team wears pink-trimmed shoes.
[RedShoes.JPG]
He insists they are red
Why toads should never wear ties:
[WhyWeDontWearTies.jpg]
T.O.A.D. = Toad Oracle Amazing Developers.  All Toad users are amazing, right?
- Donna

Source of the future-looking toad photo; we took the liberty of adding sunglasses because you are all so cool.: www.digitalcinemareport.com/Sundance-Cane-Toads-Barco-Dolby
Source of toad in suit: “The Larkin Toad…in celebration of the life and work of the city's most famous son, Philip Larkin:” www.guardian.co.uk/books/2010/may/12/philip-larkin-toads-25th-anniversary