Hello, you are not logged in.  Login or sign up
Community >> Quest Experts' Blogs
 Search
Steven Feuerstein's Blog
 
Author: StevenFeuersteinTW Created: Thursday, October 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.

Single quotes and CLOBs in 10.2.0.3
StevenFeuersteinTW Wednesday, December 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 Tuesday, December 04, 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 Wednesday, November 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 Sunday, November 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 Thursday, October 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 Wednesday, September 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 Thursday, September 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 Friday, September 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 Wednesday, August 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 Wednesday, August 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...

Search Blog Entries
 
Copyright 2008 by Quest Software  | Terms Of Use | Privacy Statement | Contact Us