SQLfail

Musings on Oracle and life via the medium of SQL, every Monday and Friday

Please, format your code

 Oracle, PL/SQL  No Responses »
Jan 302012
 

 Posted by Chris Saxon at 20:31  Tagged with: code formatting

The learning process

 Select  No Responses »
Jan 272012
 

 Posted by Chris Saxon at 19:20  Tagged with: mistakes, select

Surely it should be singular?

 Oracle, Select  No Responses »
Jan 252012
 

 Posted by Chris Saxon at 20:36  Tagged with: dual

Use bind variables to vaccinate your database!

 Dynamic SQL, Oracle  No Responses »
Jan 232012
 

 Posted by Chris Saxon at 20:23  Tagged with: sql injection

Find something you kick ass at

 Explain plan, Life, Work  No Responses »
Jan 202012
 

 

Inspired by Cal Newport

 Posted by Chris Saxon at 17:37  Tagged with: explain plan, job

When should an index be rebuilt?

 Uncategorized  No Responses »
Jan 182012
 

 Posted by Chris Saxon at 20:42  Tagged with: index, rebuild

Just join

 Joins, Oracle  No Responses »
Jan 162012
 

 Posted by Chris Saxon at 21:11  Tagged with: joins

Row by row by row

 Loops, Oracle  No Responses »
Jan 132012
 

 Posted by Chris Saxon at 17:29  Tagged with: row by row

The case for implicit cursors

 Cursors, Oracle  No Responses »
Jan 112012
 

 Posted by Chris Saxon at 20:23  Tagged with: cursors, implicit

The case against explicit cursors

 Cursors, Oracle  No Responses »
Jan 092012
 

 Posted by Chris Saxon at 21:14  Tagged with: cursors, explicit
 Older Entries

desc sqlfail

This site is a project to explain Oracle concepts (or other subjects that interest me) using simple SQL or PL/SQL statements.

If you'd like to know more about me you can do so here

If you'd like to get in touch, you can tweet me @chrisrsaxon

Follow Me

RSS

Popular posts this month

  • All my tables are full of lies, lies I tell you!
  • The Pareto Principle for Tuning
  • Accidentally deleted data? Just flash it back!
  • Where did all the decimals go?
  • Some things have to be serially

Categories

Suggest an SQLfail

If you'd like to suggest a post, you can do so here

Tags

11g alter table analytics averages baby bitmap index blocking change management commit constraints create procedure create table create trigger cursors database design data warehouse date conversion delete dual explain plan flashback foreign key hints index insert into lag loops mental failing merge myths null package partitions performance pl/sql procrastination rownum select sequence table triggers update upsert wait events when others

Recent Posts

  • The Ordered Sequence Fallacy
  • All my tables are full of lies, lies I tell you!
  • Who cares if what you’ve got is wrong, just make it right from now on
  • The Pareto Principle for Tuning
  • Apparently, the US doesn’t recognise non-dollar currencies

Archives

  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
© 2012 SQLfail Suffusion theme by Sayontan Sinha