Yesterday my pal -BI Specialist - described me an oracle problem :
there's an oracle database which contain large amount of information however they don't make column for every table that store Produced datetime for every row.
So within this situation Just how can he get Produced datetime (timestamp) for every row ?
Every row features its own System Change Number (SCN). This really is determining precisely a minute within the database.
First discover the SCN and according to it use SCN_TO_TIMESTAMP to obtain the time-stamp:
SELECT SCN_TO_TIMESTAMP(ora_rowscn) FROM MyTable