PL/SQL Table Functions
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.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
music: bensound.com
In questa pagina del sito puoi guardare il video online PL/SQL Table Functions della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Oracle Developers 05 settembre 2018, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 4,143 volte e gli è piaciuto 29 spettatori. Buona visione!
