What's the created Date-time for Table row in Oracle?

Yesterday my friend -BI Specialist - explained me an oracle problem :

there's an oracle database that contain huge amount of data but they don't make column for each table that store Created datetime for each row.

So i开发者_StackOverflown this case How can he get Created datetime (timestamp) for each row ?

---

Every row has its own System Change Number (SCN). This is identifying precisely a moment in the database.

First find out the SCN and based on it use SCN_TO_TIMESTAMP to get the time-stamp:

SELECT 
  SCN_TO_TIMESTAMP(ora_rowscn),
  MyTable.*
FROM 
  MyTable