Ponder Stibbons questions

Ponder Stibbons answers

• In Oracle, how to do Rank() (or any other ways that work) down to group level instead of row level?
• Oracle: Dynamically set all NOT NULL columns in a Table to allow NULL
• SQL query to fill multiple needs with partial quantities by using Oracle SQL window functions
• insert trigger in pl/sql
• 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