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"




Answers were Sorted based on User's Feedback



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

Answer / suman rana

select * from T2
minus
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  






Categories
  • 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)