When you don’t have all the info you need at compile time to write a complete SQL statement, it’s time to go dynamic (run-time construction and execution of SQL). In this Feuertip, Steven offers some tips for writing – and quickly fixing errors in – dynamic SQL.
A different PL/SQL tip every week!