Tuesday, March 28, 2006

Bookmark This Page

To ease the task of browsing my archives, I've put together an organised list of my previous posts. Bookmark this, because I will keep it up to date. I will also include a link to this post under Archives.

Note: If you comment on an older article, I will get an automatic email. So I will see it and I will respond to it, so please feel free to do so!

For Newbies:

Tuesday, December 20, 2005
20 Beginner Oracle Questions

Friday, June 17, 2005
Asking For Help - Tips on where to go and how to do it.

Wednesday, July 19, 2006
Finding Information - How do you find answers to other questions?

Thursday, July 14, 2005
Oracle Docs - For when people tell you to RTFM!

Best Practices:

Thursday, October 19, 2006
3 Easy Ways to Improve Your PL/SQL - Improving your code through instrumentation and bulk processing.

Friday, March 09, 2007
40 Tips From Tom (Kyte)

Tuesday, June 14, 2005
Bind Variables in PL/SQL - Short answer: PL/SQL binds all variables (with some exceptions like dynamic SQL)

Tuesday, January 24, 2006
Gathering Requirements

Wednesday, March 01, 2006
Handling exceptions - A how-to guide.

Friday, March 10, 2006
Handling Performance Issues

Wednesday, August 17, 2005
Keeping Tables Small - In terms of number of rows, not columns. Improve performance.

Monday, October 31, 2005
Oracle Packages - And why/how you should use them.

Monday, July 11, 2005
Specifying INSERT Columns - Why it's a good habit.

Wednesday, May 18, 2005
Steven Feuerstein on Refactoring

Tuesday, July 26, 2005
Use Constraints - A how-to guide for people to whom I BEG to let the database handle the data's integrity.

Monday, July 25, 2005
Use Views - Why they're handy.

Tuesday, September 12, 2006
Using Numerical Fields - Don't use them for fields that aren't real numbers.

Oracle Packages:

Wednesday, October 12, 2005

Thursday, November 24, 2005
DBMS_PIPE - For communication between sessions

Sunday, August 14, 2005
UTL_HTTP - Including an example of how to get a stock quote from the Internet.

Top 20 Lists:

Sunday, January 15, 2006
Oracle DO NOTs - From AskTom

Tuesday, December 20, 2005
20 Beginner Oracle Questions

Monday, September 12, 2005
20 Oracle Lessons - After my first few months of blogging.

Monday, December 19, 2005
20 PL/SQL Coding Tips - Inspired by an AskTom thread

Tuesday, October 17, 2006
Software Vendor Customer Support - How to improve your luck when dealing with support (ok there are only 14)

Book Reviews:

Wednesday, June 22, 2005
Expert One-on-One - A couple of mistakes from my favourite Oracle book.

Monday, May 16, 2005
Optimizing Oracle Performance (Millsap, Holt)

Wednesday, November 02, 2005
Oracle Insights: Tales of the Oak Table

Thursday, June 23, 2005
PL/SQL Books - A list of my three favourite PL/SQL books


Thursday, June 30, 2005
OOP in PL/SQL? Yep

Wednesday, July 13, 2005
Stored Procedure template

Great Debates:

Wednesday, April 23, 2008

Bashing RDBMS

Tuesday, June 21, 2005
Natural vs Synthetic keys - Choosing primary keys.

Wednesday, March 29, 2006
Optimizer - Should we be overriding it in our application?

Monday, September 19, 2005
PL/SQL Code Storage: Files vs In-DB Packages

Wednesday, January 18, 2006
PL/SQL vs J2EE - Where should you put the business logic?


Tuesday, February 24, 2009
Get Rid of NULL - Possibly the only viable solution to these problems.

Friday, September 09, 2005
NULLs in COUNT - Why counting on a column might get you a different total.

Friday, June 10, 2005
NULLs in Oracle

Tuesday, May 17, 2005
NULL vs Nothing - ANSI SQL is unlike programming languages because NULL is not nothing.


Monday, June 13, 2005
Blank Lines and SQLPlus

Friday, May 20, 2005
Multiple Foreign Keys on the Same ID

Monday, July 04, 2005

How-To Guides:

Wednesday, September 14, 2005
Analyzing Query Performance - using SQLTRACE and TKPROF

Friday, May 04, 2007
ANSI Joins - Or do you want to stick with the old school style?

Friday, April 18, 2008
Avoid Deprayments - Learn how to test that your database application is connecting

Tuesday, February 14, 2006

Tuesday, January 17, 2006
Bulk Binding: FORALL - Improve performance of bulk updates.

Monday, August 02, 2010
Change a User's Default Schema - Several ways.

Thursday, January 22, 2009
Cleaning up with ALL_TAB_COLS

Thursday, September 22, 2005
Column Name as a Variable

Thursday, June 16, 2005
Common Table Column Types - Two tables with columns on the same type, but not actually related.

Wednesday, August 24, 2005
COMPUTE - How to emulate a feature found in other languages

Saturday, June 18, 2005
Connect By - Heirarchical queries, something you need to know.

Monday, June 20, 2005
Decode - CASE's precursor.

Thursday, March 25, 2010
DECODE/CASE vs. Mapping Tables - Which should you use?

Thursday, November 10, 2005
DUAL Table - You've seen it, what is it?

Thursday, May 19, 2005
Dynamically assigning size of varchar2 - You do it in other languages, can you do it in PL/SQL (and how)?

Wednesday, May 25, 2005
ENUM in Oracle - Emulating a common programming feature in PL/SQL.

Friday, July 01, 2005
Extra Columns in a GROUP BY

Tuesday, May 09, 2006
Finding Nearby Rows. Three methods of solving similar requirements.

Wednesday, August 11, 2010
FIRST_ROWS vs ALL_ROWS - What's the difference?

Sunday, October 21, 2007
Global Temporary Tables. The ultimate work tables!

Monday, August 01, 2005
Import Export

Tuesday, February 23, 2010
Improving your SQL Queries

Monday, May 28, 2007
Multirow Inserts - Does Oracle support the ANSI SQL standard of inserting multiple rows? No. But here's how you can fake it.

Thursday, May 26, 2005
NOCOPY Hint - Improve performance by changing how variables are passed to PL/SQL procedures.

Saturday, July 23, 2005
Oracle BOOLEAN - PL/SQL has BOOLEAN, here's how to emulate it in Oracle's SQL

Friday, July 29, 2005
Oracle By Example - Bringing several concepts together to solve a problem.

Friday, June 24, 2005
Oracle Client - How to install

Tuesday, July 04, 2006
Oracle and Java

Monday, October 30, 2006
Oracle Passwords - Answering your common questions

Thursday, December 15, 2005
Oracle and Perl

Thursday, February 02, 2006
Oracle and SOA - Covers Oracle's Service-Oriented Architecture at a high level

Wednesday, February 22, 2006
Oracle Sequences - This is the one Oracle carried on its main page

Friday, February 20, 2009
Overlaps - Useful. Ever heard of it?

Thursday, September 01, 2005
Pivot and Crosstab Queries - A very useful technique for turning rows into columns, and vice versa

Monday, April 03, 2006
Pivot Queries Using Variable Number of Columns - Part 2 on pivot queries, when you don't know how many columns you need in advance.

Friday, September 30, 2005
PL/SQL Procedure Call Overhead - Is there one?

Friday, August 11, 2006
PL/SQL Procedure Call Overhead Re-visited - By Zsolt Lajosfalvi

Saturday, September 02, 2006
Protecting PL/SQL Code - Using wrap.

Tuesday, May 24, 2005
Random Numbers - How to generate them.

Monday, November 21, 2005
RAW Datatype

Tuesday, June 27, 2006
Recursion vs Iteration - What are they, what are the advantages of each one?

Tuesday, June 13, 2006
Refreshing Data - A High-level picture of the flow and what to keep in mind when designing your data import strategy

Thursday, October 06, 2005
ROWNUM and ROWID - And how they're used to solve various issues, and improve retrieval times.

Tuesday, February 07, 2006
TRANSLATE - What it is, how to use it.

Wednesday, August 10, 2005
UNION ALL - How and when to avoid performance hits

Monday, April 17, 2006
Updating Views - Can you do it, and if so, when.

Monday, June 27, 2005
Using Bad Names in Oracle

Tuesday, October 04, 2005
Using DECODE to exploit COUNT/NULL feature - Applying DECODE and our knowledge of COUNT/NULL together in a little trick to speed up a query.

Wednesday, June 15, 2005
Variable Constraints - Can you use variables in constraints? How?

Friday, November 10, 2006
View Constraints - Can you manage integrity using views?

Monday, July 18, 2005
Which instance am I in?

Tuesday, May 30, 2006
Windowing Clauses - How they are used to empower your analytic functions.


Monday, February 26, 2007
Fun With Tom Kyte - Get a laugh out of Oracle's king of wit

Thursday, April 05, 2007
Oracle Beefs - Here are mine. What are yours?

Tuesday, October 31, 2006
Oracle Gurus - What makes an Oracle guru?

Tuesday, February 21, 2006
Oracle Interview Questions - How to come up with useful ones.

Sunday, June 03, 2007
SQL Interview Questions - Here's what I ask. Prepare for your interviews.

Friday, May 25, 2007
What Makes a Great Oracle Blog?

Fear not, I've got two posts coming up

That's good. For a moment I thought you're experiencing the blogger burnout effect. Good luck in your new job.

I've put together an organised list of my previous posts

Unlike other blogging platforms (like WordPress for example), one of the disadvantages of Google's Blogger is its inability to categorize posts so that you can easily and automatically view an archives page just like the one you just posted (nicely organized BTH).
Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?