DazzaL questions

DazzaL answers

• Automatic type generation
• Difference in Start and End times grouping by hour
• Oracle Scheduler – Creating a complex schedule with a single job
• compare within groups to fetch common value
• using define statement in PL/SQL developer
• get all parent records from child record
• Oracle SQL group by single field and count the grouped rows
• TO_DATE returning different dates for different format masks?
• return resultset from function
• force subquery resolution first