A lot of functionality is provided by Oracle Database out of the box. Most common functions and procedures are at your fingertips. But what do they offer when you need something not provided by Oracle? Suppose you have to figure out the total work hours when you only have a check-in and check-out time. An aggregate to sum up the interval differences between the start and end times would be very helpful. ...
8. Polymorphic Table Functions and SQL Macros
Get Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.