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
- 3962 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 |
where do i find oracle interview questions.
What happens if the update subquery returns multiple rows?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
Can we convert a date to char in oracle and if so, what would be the syntax?
Explain joins in oracle?
what are pseudocolumns?
How are extents allocated to a segment?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
How to shutdown your 10g xe server from command line?
How to use windows user to connect to the server?
Oracle General 
