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

What is Normalization ?

55 Answers   IBM, ACS, TCS, Keane India Ltd, Genpact, Graphix Solution, Vault,


How to best split csv strings in oracle 9i?

0 Answers  


how to store only time in a data base table

2 Answers  


How translate command is different from replace?

0 Answers  


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 ?

2 Answers  






What are a collation and state the different types of collation sensitivity?

0 Answers  


What are the common oracle dba tasks?

0 Answers  


What happens to indexes if you drop a table?

0 Answers  


which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 Answers  


what is difference between sql plus and sql*plus? (not sql and sql plus).

0 Answers  


What is oracle instant client?

0 Answers  


How to delete all rows a table in oracle?

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • 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 (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)