Tag Archives: SQL
Quick note on how to update data in a series of joined tables using a subquery in the UPDATE statement in Oracle, kind of like the...
This is the equivalent code for writing a switch statement in Oracle. In Oracle to do the switch we use a function called case. Which looks...
Quite useful, I had the case where I needed to provide a CSV file to an external party from our Oracle 10g database. No problem, there...
So you use MySQL etc… and you’re used to adding a LIMIT clause to your query for example, SELECT * FROM table WHERE name = ‘bob’...