tbone questions

tbone answers

• redirect plsql error message to a log file when executing it in sqlplus
• Oracle TOP N ordered rows
• Why doesn't PL/SQL respect privileges granted by Roles?
• Running PL/SQL calls in parallel and wait for execution to finish (fork and join)
• select most recent values in very large table
• Oracle blocking repeated inserts
• Creating tables with circular reference
• Can Oracle's user-defined aggregation function be defined for use with two columns?
• Oracle - Is it possible to "set" values inside case statement during update as below?
• Should I use Oracle's sys_guid() to generate guids?