Today’s video demonstrates how to expand SQL references to views using the DBMS_UTILITY.EXPAND_SQL_TEXT procedure. This functionality was introduced in Oracle 12.1.
The video was based on this article.
- DBMS_UTILITY.EXPAND_SQL_TEXT : Expand SQL References to Views in Oracle Database 12c Release 1 (12.1)
The stars of today’s video are Sanjay Kumar, Baljeet Bhasin and Jagjeet Singh, who I met and chatted to at a previous OpenWorld. 🙂