Interested to Buy Any Domain ? << Click Here >> for more details...
T1: T2
A X--- this is updated record
B B
like this T1 table having no.of records updated. write a
query"retrive updated record from T2"
- 2 Answers
- 4859 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Differentiate between post-database commit and post-form commit?
What is the usage of analyze command in oracle?
what is a view?
What is MTTR advisor in Oracle?
What is oracle host variable?
What is the difference between an Oracle Schema and an Oracle Instance?
How to put more than 1000 values into an oracle in clause?
What is oracle analytical function?
defination of bitmap index
How to assign query results to variables?
What is oracle instant client?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
Oracle General 
