Ponder Stibbons questions

Ponder Stibbons answers

• Very slow query when using CONNECT BY LEVEL
• In Oracle 11g how do you time weight average data hourly between two dates?
• Calculating days of therapy in a sql query
• Getting a count by value of all columns in a table using Oracle SQL
• Sorting Multiple Parent/Child on Recursive SQL Query
• Finding difference in months using analytical function in oracle
• Insert xmltype into xmltype in specified place [PL/SQL]
• Joining 2 tables to calculate the time difference
• Oracle SQL, always show three lines in query with unions
• Oracle 10 how to update a table as a sum