It is necessary to display zalog.id, by which overvallue.vallue and liquidity.name were changed, indicating the given changes. How can I do that?

Question

Oracle

It is necessary to display those ids for which there were changes in the fields overvalue.value and liquidity.name and in a separate column what changes were

Answer 1

First you need to clarify what exactly were the changes in the overvalue.value and liquidity.name fields, but in principle the request is like this:
select zalog.id from zalog, overvalue, liquidity
where zalog.id=liquidity.id
and zalog.id_ov= overvalue.collection_id
and overvalue.value = --set the value
and liquidity.name = --set the value
or, at the extreme, write the trigger code for updating/inserting/deleting data in the overvalue.value and liquidity.name fields!