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"
Answer Posted / suman rana
select * from T2
minus
select * from T1
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the best way to do multi-row insert in oracle?
Explain the difference between sap and oracle?
How to create a new user account in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to use windows user to connect to the server?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to use attributes of the implicit cursor in oracle?
What is MTTR advisor in Oracle?
How to sort output in descending order in oracle?
What are the differences between blob and clob in oracle?
What is data block in Oracle?
What is oracle server autotrace in oracle?
How to increment dates by 1 in oracle?
How will you differentiate between varchar & varchar2?
What is clustered table in Oracle?