T1: T2
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

T1: T2 A X--- this is updated record B ..

Answer / suman rana

select * from T2
select * from T1

Is This Answer Correct ?    0 Yes 1 No

T1: T2 A X--- this is updated record B ..

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

Post New Answer

More Oracle General Interview Questions

please explain.. DB architecture ...

0 Answers  

how do u know the total no of rows in a table?

5 Answers  

how to hide the stored procedure inside a package

1 Answers  

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

what are Triggers?

6 Answers   TCS,

how to insert data into partitioned table partition done by Range partition

1 Answers  

What do you mean by redo log file mirroring?

0 Answers  

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers  

What would you do with an in-doubt distributed transaction?

0 Answers  

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

Display the number value in Words?

1 Answers  

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers  

  • Oracle General Interview Questions Oracle General (1003)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (0)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (484)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (0)
  • Oracle RAC Interview Questions Oracle RAC (20)
  • Oracle D2K Interview Questions Oracle D2K (53)
  • Oracle AllOther Interview Questions Oracle AllOther (241)