OracleBlog: Bookmark This Page: "Bookmark This Page"
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.
Thursday, July 14, 2005
Oracle Docs - For when people tell you to RTFM!
Best Practises:
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.
Oracle Packages:
Wednesday, October 12, 2005
DBMS_OUTPUT.PUT_LINE
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.
