Tag Archives: PL/SQL
Quick method to do multiple actions across multiple tables. Simply spool a script with your commands in for each table – this way you can avoid...
Joining columns and results together is really easy in Oracle or MySQL, in both there is the same function – CONCAT(). However you should be aware...
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...