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|
please explain.. DB architecture ...
how do u know the total no of rows in a table?
how to hide the stored procedure inside a package
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.
what are Triggers?
how to insert data into partitioned table partition done by Range partition
What do you mean by redo log file mirroring?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What would you do with an in-doubt distributed transaction?
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
Display the number value in Words?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?