Pattern Matching + SQL Macros = Pure SQL Awesomeness!
Added in Oracle Database 12c, SQL pattern matching (match_recognize) makes it easy to answer many questions that were hard-to-impossible with SQL.
But turning match_recognize clauses into reusable functions was tricky at best.
No more!
Added in 19.6, SQL macros enable you to define reusable code fragments. These return SQL that becomes part of your final SQL statement.
**********
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://www.oracle.com/cloud/free/
This session will show you how you can combine SQL macros and match_recogize. Together these enable you to write generic functions answering common questions such as "find me all the consecutive rows".
Смотрите видео Pattern Matching + SQL Macros = Pure SQL Awesomeness! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Oracle Developers 18 Июнь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 11,089 раз и оно понравилось 62 людям.