PL/SQL Table Functions

Publicado em: 05 Setembro 2018
no canal de: Oracle Developers

4,143

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

Nesta página do site você pode assistir ao vídeo on-line PL/SQL Table Functions duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Oracle Developers 05 Setembro 2018, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 4,143 vezes e gostou 29 espectadores. Boa visualização!

190