Using Predicated Privileges

Use set show_transformed_sql to display the SQL text.

Use set show_transformed_sql with set noexec to display the text of an SQL query, but not execute the query.
When you enable show_transformed_sql for a session, DML or select commands displays the SQL text of:
- Predicate text, if predicates exist on tables in the SQL command. If no predicates exist, show_transformed_sql displays NULL.
- User query text
- SQL text of the query after aggregate processing, view processing, encryption, and predicate merging. For queries that do not access any predicates, the SQL text denotes the text after view processing, encryption, and so on.
- SQL text of the query after subquery processing.