Expanding the Text of a SQL Query Using the EXPAND_SQL_TEXT Procedure of DBMS_UTILITY
(Doc ID 1953022.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
The DBMS_UTILITY.EXPAND_SQL_TEXT procedure allows you to expand an input SQL statement such that the resulting query text only contains references to underlying tables and is semantically equivalent. For details refer to:
Database PL/SQL Packages and Types Reference
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document