Held on September 3 2018
Table functions are very cool: they are functions that return collections, and can be called in the FROM clause of a SELECT, as if it were a table or view. In this session, Steven Feuerstein starts with a quick intro to and demos of table functions. We then shift to answering your questions on this useful feature, including (new to 18c) polymorphic table functions and interactions between table functions and the SQL optimizer.
1:54 Whirlwind overview of table functions
9:48 LiveSQL demonstrations
24:42 Q&A: Materialized views and table functions
25:56 Q&A: Recommendations for organizing types needed for table functions
28:44 Introduction and overview of 18c polymorphic table functions
40:30 Table functions and the SQL optimizer
48:17 Table functions and SmartDB
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
[ Ссылка ]
Oracle Developers portal: [ Ссылка ]
Sign up for an Oracle Cloud trial: [ Ссылка ]
music: bensound.com
