|
|
 Blogs
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
By e0aba78c-c04c-4ee1-a696-90b499bc5cc8 on
Friday, May 28, 2010 7:33 AM
This blog is the seventh in a series about misconceptions surrounding SQL tuning that are quite common.
|
By 362dce9c-a552-4b5b-ac95-ab109db9f2a6 on
Thursday, May 27, 2010
On 24 May 2010, I presented a one-hour webinar on some of the challenges we database programmers face setting up regression tests for programs that change database tables.
Here's the description:
"Most PL/SQL programs modify the contents of one or more tables. How can you verify that the modifications were correct? This is one of the biggest challenges facing PL/SQL developers.
"Join Steven Feuerstein...
|
By Bert (User) on
Monday, May 24, 2010 6:06 AM
I wrote a blog a few weeks back titled TOAD 10.5 Freeware Runs on Linux. So here comes the second and more important part for many – getting the official commercial product installed and working on Linux. And to me great and very happy surprise, the install simply worked. Look at the screen snapshot below. It shows that I now have both the TOAD freeware and commercial installed and working side by side on my Ubuntu 10.04 Linux machine. Hurray! ...
|
By 362dce9c-a552-4b5b-ac95-ab109db9f2a6 on
Monday, May 24, 2010
When it comes to making sure your program works as it should, there are two general categories of test cases:
Tests of requirements: every requirement needs to have at least one test case devoted exclusively to verifying that the requirement has been met: the code performs as required. If you don't test for a requirement, then you do not know if it works. It is, ahem, theoretically correct. In other words, it is very likely buggy....
|
By Bert (User) on
Monday, May 17, 2010 5:45 AM
Toad is a robust and mature tool – so there are many more features than most of us can ever hope to master. But one that’s very useful yet widely unknown is the ability in the Schema Browser to perform intelligent/contextual jumps to related items.
|
By ce4e6745-3fec-406d-b3e5-5aa35edbc5fd on
5/17/2010
What’s the first thing we learn when it comes to databases and/or SQL? Odds are it was how to write a SQL statement to retrieve data from one or more tables.
|
By 7a7dcd3c-0d79-4d4c-859e-60cc2161339d on
5/12/2010 2:42 PM
Step by step instructions for change a TOAD Manager reports name and or category
|
By ce4e6745-3fec-406d-b3e5-5aa35edbc5fd on
5/11/2010
Today I want to talk about something that should be beneficial to any person who has ever needed to connect to an Oracle database, comparing data.
|
By Bert (User) on
Monday, May 10, 2010 8:59 AM
I’m running Toad for Oracle 10.5 freeware “natively via WINE” on Linux – specifically Ubuntu 10.04. Therefore you can now run the world’s favorite Oracle database tool on Linux. Goodbye Windows!
|
By StevenFeuersteinTW (User) on
Monday, May 10, 2010 6:09 AM
I recently received this question from a PL/SQL developer:
"What is the maximum size of a PL/SQL procedure?"
The answer is interesting: there is not a maximum size, per se. Instead, the limitation has to do with the maximum number of DIANA nodes your program generates in the compilation process.
DIANA is an intermediate language produced and used by the compiler. DIANA standards for “Descriptive Intermediate Attributed Notation for Ada" - and reminds us that PL/SQL is based on Ada, a programming language originally developed for the U.S. Department of Defense. ...
|
By Bert (User) on
Monday, May 10, 2010 4:51 AM
Quest recently released a new and updated version of the Toad for Oracle freeware. The old freeware was based on the old Toad 8.5 code base which came out before 10gR2, 11gR1, and 11gR2. So for example it had some problems supporting database versions and features that came out years later (e.g. 11g case sensitive passwords). The new freeware is based off the latest and...
|
By ce4e6745-3fec-406d-b3e5-5aa35edbc5fd on
5/10/2010
It’s been about 2 weeks now, and I’ve already found a few things that’s I’d consider ‘upgrade worthy’ regarding Toad for Oracle v10.5. Whether they be groundbreaking new features, or just convenient behavioral updates, here a few things to look for when you’re ready to upgrade.
|
By StevenFeuersteinTW (User) on
Wednesday, May 05, 2010 6:17 AM
I received yesterday this email from a PL/SQL developer:
I am stumped. My PL/SQL code does not seem to be handling dates properly. Here is a block of code I extracted from my actual program to demonstrate the problem:
DECLARE global_end_date DATE := '04-May-2010'; global_beg_date DATE := '01-May-2010';BEGIN IF TRUNC (SYSDATE) > TO_DATE (global_end_date, 'DD-MON-YYYY') THEN DBMS_OUTPUT.put_line...
|
By Bert (User) on
Monday, May 03, 2010 6:26 AM
The first blog on this topic demonstrated the two primary methods by which to automate a DBA task in Toad such as the popular Database Health Check report. We saw that either using the “DB Health Check” screen (i.e. METHOD-#1) or the “App Designer” directly (i.e. METHOD-#2) how to create the automated task or action – plus how to schedule it and...
|
|
|