What is the created datetime for a table row in Oracle?

Question

Yesterday, my BI friend friend explained to me the oracle problem:
there is an oracle database that contains a huge amount of data, but they do not create a column for each table in which the created dates and times for each row are stored.
So, in this case, How can he get the Created datetime (timestamp) for each row?

Answer 1

Each line has its own system change number (SCN). This accurately determines the moment in the database.

First find the SCN and on it use SCN_TO_TIMESTAMP to get the timestamp:

SELECT SCN_TO_TIMESTAMP(ora_rowscn) FROM MyTable