Updating two tables in oracle
I belive fully portable or “platform-independent” SQL is mostly a myth.Writing generic “standard” SQL to the lowest common denominator almost certainly results in under-utilizing the RDBMS’s abilities.Getting the most from my software is more important than dreaming of “platform-independent” queries.
That’s a terrible way to update data, but for various reasons, I’m sure many readers have found themselves in a similar situation.
In this article I have discussed several ways to use such non-standard extensions in My SQL for performance and convenience. Not only does it potentially make code non-portable, it can encourage mediocrity by teaching bad habits instead of teaching people the “right” way to do things.