Three Cheers & Toad Week is here [2 Attachments]

Sent from my iPhone
Begin for
From: Donna Buskirk <[email protected]<mailto:[email protected]>>
Date: May 31, 2012 4:09:08 PM EDT
To: Mark Lerch <[email protected]<mailto:[email protected]>>
Subject: RE: Mark, edit away! DRAFT Toad Week

salol

Donna D. Buskirk
Content Developer|Toad for Oracle Quest Software - Simplicity at Work | 919.650.4505 | www.quest.com<http://www.quest.com/>

From: Mark Lerch
Sent: May 31, 2012 4:08 PM
To: Donna Buskirk
Subject: RE: Mark, edit away! DRAFT Toad Week

If your light goes out it is because you have started loving less. If you let your candle go out God will be forced to remove it from its place, but he'll never quench it if it is still smoldering. Great works and great suffering, even for God's name, mean little if you don't have love.

-Revelation 2.1-5; Matthew 12.20; 1 Corinthians 13.1-3

oh, for the newsletter?  no.

From: Donna Buskirk
Sent: Thursday, May 31, 2012 3:56 PM
To: Mark Lerch
Subject: RE: Mark, edit away! DRAFT Toad Week

OK then tomorrow is publication date. :)
Want to share a tip?

Donna D. Buskirk
Content Developer|Toad for Oracle Quest Software - Simplicity at Work | 919.650.4505 | www.quest.com<http://www.quest.com/>

From: Mark Lerch
Sent: May 31, 2012 3:55 PM
To: Donna Buskirk
Subject: RE: Mark, edit away! DRAFT Toad Week

you won't know unless you try.  step out!

From: Donna Buskirk
Sent: Thursday, May 31, 2012 3:45 PM
To: Mark Lerch
Subject: RE: Mark, edit away! DRAFT Toad Week

Yeah, but – yeah but -

You wanted to edit it, right? I only did some things because I knew you’d say NO, like making Michael’s head fat.

Should I get more tips/content?

Donna D. Buskirk
Content www.quest.com<http://www.quest.com/>
[https://encrypted-tbn0.google.com/images?q=tbn:ANd9GcTC5L-mwEO-RNAUiV4N-ninLBa4EayftnACC_O7oyRp28TyeLa0]
Toad Week, Toad Strong!
Weekly tips to strengthen your use of Toad for Oracle

Introducing a weekly email in which we PROMISE not to waste your time. Read what you need and pass on the rest.

Hi there,
Take a little time – it’s worth it!
Your time here should pay off in saved time, and with gratification from associating with Toad Developers &  users worldwide.

Contents
Personal tips from:

-          Our Development Team

-          Power Users

-          Beta list
Plus, new videos from PM, a Support Solution, and my favorite line from the lists.

“AHA!”
There is  SO MUCH in Toad for Oracle – we can’t know it all, but surely we will learn from each other here.

Email me<mailto:[email protected]?subject=AHA!> with “AHA!” in the subject line to share your favorite tip or the thing you learned that you wish you had known sooner!
Dev Team
Tip from Michael:
Source: Idea Pond #618

The Editor has a relatively new feature that can create a list of strings from a list.
You can save this as a macro.
Select the text you've pasted in the Editor. Open the replace dialog and select the Regular Expression option.
- Search for: (?s)$\s+^
- Replace with: ', '
- Click Save and give it a name. I called mine Pass1 for this example.
This takes care of all but the leading and trailing quote. Go back into the replace dialog and do another regex replace.
- Search for: ^.*$
- Replace with: '$0'
- Click Save and give it a name. I called mine Pass2.
You can now load those settings into the save dialog using the open button or you can easily recall them without the dialog using the little dropdown arrow beside the replace button on the Editor toolbar.


Michael Staszewski’s tenth year here!
Toad wouldn’t be Toad without him.
[Mikes10Year.jpg]
Is his head getting big lately?
Manager and Developer Mark Lerch presents the Quest Software ten-year plaque to Michael.
Here’s to ten more!

Tip from DocuDonna:
Remember to pass the torch well.
Document your process so those who come behind you don’t get lost.
Back to top
Power Users
WHO is a power user? You are!
Your questions and your answers help all of us work more efficiently.
Q:
Hello everyone,
I need to add three columns via an Alter table script and I need default values on two of the columns.  Problem is there is significant data in the tables and I do not want to add the default values to the existing rows.  I understood there was a keyword that I could use for this.  I am not able to find anything.  Any help appreciated.

A:
It looks to me as if adding a column, with a default, causes the default
to be propagated to all existing rows I'm afraid.

What I think you can do is add the columns and afterwards do an alter
table to add in the default.

Set up a small test table and try it out with a couple of rows. See how
you get on.

…So if you want to add a column, populate all existing rows with the value X, and then have the value Y as the default for new rows, you do:
ALTER TABLE tb ADD (cl DEFAULT ‘X’);
ALTER TABLE tb MODIFY (cl DEFAULT ‘Y’);
Cheers,
Norm. [TeamT]
Result:
Confirmed!  This works to leave the value on the existing records as null.
Also confirmed, I just tested it.  I will need to copy 116 rows in the script to do a secondary alter command adding the defaults after adding the columns.
Thanks everyone, I got what I needed and it worked fine.

Back to top

Beta-list Q & A
The best of the non-beta related Q&A from our Beta users’ group.

Many thanks to this dedicated group of Toad for Oracle users who literally help us create Toad. They’re not afraid of bugs!

Email excerpts:
On Behalf Of Phyllis Helton
Subject: [toadbeta] RE: File Recovery Question
Fortunately, my buddy John D. showed me this very cool trick about Ctrl-Clicking and dragging files onto one another in the editor to compare contents so I was able to fairly quickly see whether or not the files were in sync.  :)

New videos posted by Program Manager, Amit Parikh
Many thanks to Amit for taking the time to create the new videos listed in the table below.
By the way, here’s his blog: http://toadworld.com/Blogs/tabid/67/rssid/50/Default.aspx

What's New for Developers in Toad for Oracle 11.5

Quest TV<http://quest.com/tv/All-Videos/1642834948001/Whats-New-for-Developers-in-Toad-for-Oracle-115/Video/>
YouTube<http://www.youtube.com/watch?v=jzX-tHk9aJw>

What's New for DBAs in Toad for Oracle 11.5

Quest TV<http://quest.com/tv/All-Videos/1642834949001/Whats-New-for-DBAs-in-Toad-for-Oracle-115/Video/>
YouTube<http://www.youtube.com/watch?v=WuWAd-SMX8s>

Toad DBA Suite for Oracle Product Overview

Quest TV<http://quest.com/tv/All-Videos/1642914265001/Toad-DBA-Suite-for-Oracle-Product-Overview/Video/>
YouTube<http://www.youtube.com/watch?v=rIr-yRcNcIQ>

Toad Development Suite for Oracle Product Overview

Quest TV<http://quest.com/tv/All-Videos/1642853174001/Toad-Development-Suite-for-Oracle-Product-Overview/Video/>
YouTube<http://www.youtube.com/watch?v=sZ7XF2CbDsI>

Back to top
Support Solution
Here’s the link to the solution below:
https://support.quest.com/Search/SolutionDetail.aspx?id=SOL92972&category=Solutions&SKB=1
By the way, our Support Team won the 2012 Achievement in Customer Excellence Award<https://support.quest.com/Search/SolutionDetail.aspx?id=SOL92972&category=Solutions&SKB=1>!
Way to go, Support!
Solution SOL92972
Title: Toad truncating data on input using Import Table Data
Problem Description: When importing from an Excel file, Toad is truncating data when it shows the Preview screen. On closer inspection, it appears that the wrong columns are being mapped i.e. B is mapping to C, C is mapping to D. This results in data truncation when the wrong table column is specified.
Cause: First column in Excel file is empty (null)
Resolution: WORKAROUND – Open the Excel file and on the first cell, <right click> Format cells
Selected 'Custom' which highlights 'general'
Click OK
Save file
Repeat Import Table Data Wizard
STATUS
Waiting for fix in a future release of Toad for Oracle

Favorite line from the lists
“Disclaimer:
Woof!”

Encourage someone!
-Donna

Donna D. Buskirk
Content Developer|Toad for Oracle Quest Software - Simplicity at Work | 919.650.4505 | www.quest.com<http://www.quest.com/>