Blogs

Home

Products

Community

Experts

Knowledge

Downloads

Hello, you are not logged in. Login or sign up

Blogs
Toad and Database Commentaries

Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.

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.

Author:	StevenFeuersteinTW	Created:	10/26/2006 10:47 AM
Life’s short and there’s more to it than coding. How can we change the way we write our programs so that we can spend less time in front of a screen and more time with family, friends and planet earth? Visit my blog for tasty, tight, tidbits of advice and code that you can put to immediate use in your world of programming.

Don't start with a blank slate!
StevenFeuersteinTW	9/26/2007 10:23 AM

Use templates to accelerate high quality coding. When you open a new edit window in Toad, it looks like this:
Comments (0)	Read More...

Quseful #8: Execute DDL statements from a file
StevenFeuersteinTW	9/20/2007 10:37 AM

What's the point? This utility will make it easy for you to read in the contents of DDL statements (like CREATE OR REPLACE PACKAGE) and execute them within Oracle.

Comments (0)	Read More...

In what version did Oracle add that feature?
StevenFeuersteinTW	9/14/2007 11:08 AM

I get this question a lot. I am teaching a class and a student asks: "When did Oracle add autonomous transactions?" Or the INDICES of clause. Or – who knows what? Seeing as I am totally obses ...

Comments (3)	Read More...

Quseful #7: Kill those infinite loops!
StevenFeuersteinTW	8/29/2007 12:42 PM

I don't know about you, but I sometimes write code that (inadvertently, not on purpose) contains an infinite loop. So I run my program and Toad goes off into never-never land, with Oracle chewing up CPU cycles so intently that it is hard to connect as SYS and kill the session. ...

Comments (2)	Read More...

Undocumented But Supported Feature In Oracle11g: Reference Fields Of Records In A FORALL Statement!
StevenFeuersteinTW	8/22/2007 7:41 AM

Kudos to Alex Nuijten for bringing this gem to light, he wrote in his latest AMIS blog entry that:
Comments (2)	Read More...

Quseful #6: Generate collections of random values
StevenFeuersteinTW	8/17/2007 9:27 AM

You will find in this Quseful a package that will generate/return collections of random values of strings, numbers and dates. It also contains a "self-test" random_verifier procedure that you can run to verify "at a glance" that the values being generated seem

Comments (0)	Read More...

Quseful #5: Does that string contain a valid number?
StevenFeuersteinTW	8/6/2007 2:01 PM

I offer in this Quseful (Quick and Useful) a package that you can use to determine if a string contains a valid integer, number, binary_float or binary_double (note: if you are not running Oracle 10g, you will need to comment out the binary_* versions in this package). It is based on code I wrote about back in 1997 (available
Comments (0)	Read More...

Quseful #4: Get the value of (almost) any column from any table with dynamic SQL
StevenFeuersteinTW	7/11/2007 11:04 AM

I offer in this Quseful (Quick and Useful) a package that you can use to dynamically retrieve the value of almost any column from any table. I created this package as a "helper" utility for Quest
Comments (0)	Read More...

Confessions of a Hypocritical Programmer
StevenFeuersteinTW	6/22/2007 11:19 AM

That's me. A hypocritical programmer. And I am here to admit it, to make a confession. Hypocrisy has got to be one of the most infuriating traits of human beings.

Comments (2)	Read More...

Quseful #3: Don't put COMMIT; in your code!
StevenFeuersteinTW	6/5/2007 6:16 AM

Qusefuls #1 and #2 were published on Steven Feuerstein's personal blog at feuerthoughts.blogspot.com.
Comments (6)	Read More...