Robert Vollman

Subscribe to Robert Vollman feed
Helpful ideas and solutions for the Oracle application enthusiast. Check out the archivesRobert Vollman
Updated: 2 weeks 2 days ago

40 Tips From Tom

Fri, 2007-03-09 17:09
Everybody learns their lessons, and so will you. The only variable is how expensive the lesson is. While there is no substitute for direct, first-hand experience, the cheapest way to learn a lesson is to benefit from the experience of others.My favourite source of cheap lessons is Ask Tom. I've compiled a sample collection of Tom's Wisdom from just the articles updated in the past week. Robert Vollman

Fun With Tom Kyte

Mon, 2007-02-26 13:54
As devoted readers may have noticed, my new job doesn't involve nearly as much work with Oracle. I stay sharp by reading Ask Tom, the very site that has provided me with 90% of the answers that I can't find in Oracle documentation or figure out on my own.Those of you who may find it nerdly to spend lunch hours reading Oracle Q&A are actually really missing out. It's far more entertaining than Robert Vollman

REPOST: Pivot and Crosstab Queries

Thu, 2007-01-25 15:00
Here is another advanced concept that will come in useful when solving Oracle problems. Imagine you're trying to create a result set where the rows need to be columns, or vice versa. In essence, you need to "pivot" rows into columns, or vice versa. That is a very common requirement, and this is where you need to look at a pivot (or crosstab) query to get the job done.As always, when you want Robert Vollman


Mon, 2006-12-04 13:57
Recently I invited anyone who has been considering joining the Oracle blogging community to jump right in. Please, help me encourage John H:Robert,Way cool blog. I really need to create one too. I like to adhere to best practices and love to read stuff from Tom K. and Steven F.!I have a question on regular expression check constraints and was wondering if you can help:alter table Robert Vollman

100,000 more?

Tue, 2006-11-14 10:48
18 months.107 posts.110,000 reads.Not too long ago I reacted with humble incredulity that 10,000 people had read what I had to say about Oracle.Here I am, exactly one year later, and there have been 100,000 more visits. I'm almost afraid to continue, will I be talking about 1,000,000 in November 2007?I wonder why people are reading my blog because, despite how numerous we are, it seems like Robert Vollman