Shashi, September 29, 2023 - 4:06 pm UTC
Thanks much Chris for the response. One last query . If we do not have the access to DBA_statements /user_statements/all_statements , do we have any alternate options to check this select statement ?
September 29, 2023 - 5:48 pm UTC
You always have access to user_statements (provided you can connect as the code owner & there are no VPD or other policies disabling it).
You can check user_source too, though parsing this to find your statement can be trickier.
A reader, September 29, 2023 - 7:26 pm UTC
Ok sure. thanks chris..