A X--- this is updated record
like this T1 table having no.of records updated. write a
query"retrive updated record from T2"
Answers were Sorted based on User's Feedback
Answer / suman rana
select * from T2
select * from T1
|Is This Answer Correct ?||0 Yes||1 No|
Answer / suresh babu
select SCN_TO_TIMESTAMP(ORA_ROWSCN) from table;
This query shows all records timestamp.From this result you
can find record,which recently updated.
|Is This Answer Correct ?||1 Yes||3 No|
What is Normalization ?
How to best split csv strings in oracle 9i?
how to store only time in a data base table
How translate command is different from replace?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What are a collation and state the different types of collation sensitivity?
What are the common oracle dba tasks?
What happens to indexes if you drop a table?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is oracle instant client?
How to delete all rows a table in oracle?