Updating two tables in oracle


17-Jun-2019 11:03

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.

updating two tables in oracle-12

updating picasa 3

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.