SQL Fascination

Oracle : ambiguous join statements being accepted and executed May 1, 2014 - (0)

I came across a weird piece of SQL earlier today where my first reaction was “That is just invalid SQL”, except that I was viewing it in OEM so it clearly had been parsed and executed. Perhaps it is not too bizarre or surprising to some, but because the form of the SQL is something […]
Oracle : ANSI vs Old Style Joins August 17, 2013 - (1)
Oracle : Recursive Common Table Expressions and Parallelism April 14, 2012 - (3)
Oracle : Duplicate GUID values being returned from sys_guid() when run in parallel January 22, 2012 - (4)
SQL Server Denali – Sequences January 9, 2011 - (0)

Mobile Site | Full Site