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
- 4958 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 |
What is bulk load in oracle?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
What is the use of Control File ?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
a query to select maxmun 3 salaries of employee table
Explain what are the advantages of views?
write a query that displays every Friday in a year with date?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How to store pictures on to the database?
What are the major difference between truncate and delete?
Oracle General 
