Are there ways to translate the cell value into a field name?

Question

Oracle

Is there any way to translate cell value with field name?
There is a table:
_______________________________________________
| ID | name | email | address |
-------------------------------------------------- ----
| 1 | alex | [email protected] | new york |
-------------------------------------------------- ----
| 2 | maria | [email protected] | London |
-------------------------------------------------- ----
I store her history in this way:
_______________________________________________________________
| ID | USER_ID | field | address | date_edit |
-------------------------------------------------- ---------------------
| 1 | 2 |   address     | Moscow | |
-------------------------------------------------- ---------------------
| 2 | 1 |     email      | [email protected] | |
-------------------------------------------------- ---------------------

spoiler

maria сменила адрес на Moscow
alex сменил email на [email protected]

I want to abandon the first table and store only the history of changes for each field (the second table) and calculate the current (actual) user data values ​​​​(last change) on the fly through the View.
To do this, I need to use the value as a field (address, email).
How can I do that?

Answer 1

https://www.oracle.com/technical-resources/article...