Hi,
I've a set of tables in a database and I want to know when they where changed for the last time. I saw on the internet some functions like CHECKSUM_AGG and BINARY_CHECKSUM that run some checksums on the tables that one specified, but when I tried to use them on Oracle SQL Developer they where not recognized. I've done something like this:
SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) FROM mytable;
None of the functions were detected like sql functions and when I run the query it gave me a error like: 00936. 00000 - "missing expression". Can these functions be used in oracle sql? If yes, how?
Is there any other way to do this? I read that there is a audit feature on oracle databases but I would like to avoid that since I dont have admin priveliges.