If you can do it in a single statement, do it - This is faster than any other method.
If you can't, then do it in PL/SQL procedure.

Tamil