Justin Cave questions

Justin Cave answers

• Uppercase function names are faster than lowercase in Oracle?
• Is Oracle's ORA_HASH "random"?
• Oracle blocking repeated inserts
• Oracle - produce unique rows for each unique column value and convert rows to columns
• Altering JOB_QUEUE_PROCESSES
• Sql query optimization and profiling
• Oracle - What happens when refreshing a 'REFRESH FORCE ON DEMAND' view with DBMS_MVIEW.REFRESH
• How to get sorted result based on residential address in oracle 10g?
• How to abstract out subqueries?
• Retrieving PL/SQL procedure schema