-
Archives
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- January 2005
- December 2004
-
Meta
Category Archives: Database
Storing Time Information In Oracle
I recently had a requirement to store a time within Oracle, not a timestamp or a date – just the time. As it turns out, storing just the time information in Oracle isn’t something you can do without a little … Continue reading
ORA-06552: PL/SQL: Compilation Unit Analysis Terminated
Today I received a strange error from Oracle, for what appeared to be no good reason: ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: The declaration of the type of this expression is incomplete or malformed I received the error … Continue reading
ORA-06502: PL/SQL: numeric or value error
Today I came up against a very frustrating problem when writing some Oracle PL/SQL stored procedures and functions: ORA-06502: PL/SQL: numeric or value error When I first wrote the stored function in question, I was using VARCHAR2 types for storage … Continue reading
PostgreSQL Dynamic SQL & Quote_ident Gotchas
PostgreSQL provides two useful functions to aid in the safe development of dynamic SQL: quote_ident The quote_ident function accepts and returns a text type. Whatever text you pass into quote_ident will be suitably escaped such that you could safely use … Continue reading
WordPress Plugin: Kottke Style Archives
Are you sick of seeing WordPress archives that stretch the length of your arm? If you are, then you might have just found the next best thing to sliced bread! The Kottke Style Archives plugin is a WordPress archives plugin … Continue reading