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
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
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
You have a table with all your company’s financial transactions. There is another table which references a subset of these financial transactions (ie. transactions with certain properties).
Your current solution to maintain the integrity is to set up a foreign key, referencing the transactions table, and then write a trigger to make sure that any records reference only transactions that have
“Becoming an Oracle guru doesn’t take remarkable intelligence or a pricey Harvard degree, but it does take persistence, drive, and a dedication to excellence.”
- Don Burleson, How to become an Oracle Guru
Despite the appearance of merely trying to promote his team (most notably Steve Karam), Mr. Burleson actually raises some interesting points on a thought-provoking question.
What Makes an
Hallowe’en is a time of fright and mystery, and some of the most common, mysterious Oracle questions I collect involve passwords. Here are some tricks and treats:
How do you change an Oracle password? … If you/the user forgot it?
How are Oracle passwords stored?
Does it look the same for two different users using the same password?
Do the SQL Trace files reveal your secret password?
How do
If you follow the various blogs on the right, you’ll see that practically everybody (except me) is currently attending Oracle OpenWorld 2006. It’s an annual convention held in San Francisco late in the year. Lasts about 4 days, and costs around 2000 USD$.
I’d love to attend Oracle OpenWorld some day. Or practically any conference. I would especially like to visit the annual conference hosted
Want to know what has been calling the PL/SQL Procedure you’ve written?
Want to know how to tell how far along your long-running PL/SQL Procedure is?
What to know how to write fast mass insert/deletes like a pro?
I have found you the answer for all three, courtesy of my fine colleagues featured among my links. Allow me to guide you through these three great articles.
Who Is Calling Your
Having worked in technical support for software vendors for 4 years, I know a few strategies that can help customers get the best response.
1. Get training
Rely on the assistance of the software vendor for as little as possible. Invest in training your own people by signing them up for courses and, more importantly, giving them the time to learn the product and how your company uses it. Once
If you’re still using any of the default Oracle username/passwords on any of your databases, go change it now.
I could blog about this for 1-2 pages, but for two reasons:
1. I think it is an obvious (but oft-neglected) thing to do, and
2. You can use the time you would have spent reading my persuasive arguments to actually go change your passwords.
So go do it now.