In SQL, literals are the string or integer values representing data retrieved from the database. By default, literals are removed from SQL queries, as they can contain sensitive user data such as social security numbers, CC numbers, and so on.
To show literals in the queries, you can disable the Remove literals from the queries option.
- Click Databases.
- Click Configuration.
- In the Security section, uncheck Remove literals from the queries.
Once you uncheck the option, literals will always be displayed in the queries. You can revert to hiding the literals by checking the option.
The Database Agent does not mask the literals that occur after an inline or single line comment. This limitation applies only to Oracle database. However, you can mask literals if you use block comments.