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.

Just how popular is PL/SQL?
StevenFeuersteinTW	2/4/2008 11:56 AM

*Just how popular is PL/SQL?* And how many PL/SQL developers are there "out there"? These are surprisingly hard questions to answer. Officially and even unofficially, Oracle Corporation's point people on PL/S ...

Comments (1)	Read More...

Functions should return data only through the RETURN clause
StevenFeuersteinTW	1/7/2008 2:46 PM

You will find below an excerpt from my latest publication: the 2^nd edition of Oracle PL/SQL Best Practices. This edition is a complete rewrite of the 1^st edition. I decided that since software is still, for the most part, written by hu ...

Comments (1)	Read More...

Single quotes and CLOBs in 10.2.0.3
StevenFeuersteinTW	12/19/2007 5:41 PM

I usually write about best practice principles and general issues. Today I thought I would share a bit of my pain with you on a very specific topic: single quotes and CLOBs, and specifically on O ...

Comments (3)	Read More...

Error Management functions and features for PL/SQL Developers
StevenFeuersteinTW	12/4/2007 8:41 PM

Winter is descending on Chicago; we had our first snow (flurries, really) on Thanksgiving Day, and the sun is weak. For many, this is a depressing time – and I mean that the lack of that and cold actually does make people feel depressed. Per ...

Comments (0)	Read More...

My Favorite Templates – in one convenient file
StevenFeuersteinTW	11/28/2007 1:24 PM

Would you like to increase productivity, improve code quality, and ensure that standards are being followed? Of course you would! And one of the best ways to do that is to rely heavily on Toad's Code Templates (similar functionality exists in SQL Navigator as well).

Comments (1)	Read More...

Catching up with me at Oracle OpenWorld
StevenFeuersteinTW	11/11/2007 11:13 AM

Sorry about the late posting, but if you are interested in attending my presentations, here's the info: Session ID: S290723 Session Title: Break Your Addiction to ...

Comments (0)	Read More...

An Exercise in Refactoring: Are two files equal?
StevenFeuersteinTW	10/18/2007 8:50 AM

All files referenced in document available from: www.oracleplsqlprogramming. ...

Comments (0)	Read More...

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...