SQLfail
Musings on Oracle and life via the medium of SQL, every Monday and Friday
Avoid going to the inferno
PL/SQL
No Responses »
Feb
29
2012
It stops us all sometimes
Select
No Responses »
Feb
27
2012
Personal wait event analysis
Waits
No Responses »
Feb
24
2012
Wake up and smell the public synonym pollution
Synonyms
No Responses »
Feb
22
2012
Transdimensional databases
Database link
No Responses »
Feb
20
2012
Just because it compiles, doesn’t mean it’ll work
PL/SQL
No Responses »
Feb
17
2012
Stop committing inside loops
Loops
,
PL/SQL
No Responses »
Feb
15
2012
Unnecessary date converisons
Select
No Responses »
Feb
13
2012
It’s all about the hash join
Explain plan
No Responses »
Feb
10
2012
Avoiding duplicates (the hard way)
Constraints
2 Responses »
Feb
08
2012
Older Entries
