select * from T2 minus select * from T1

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"

Question Posted / suman rana

Answer Posted / suman rana

select * from T2
minus
select * from T1

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to speed up webrick?

1121

What are the different types of partitions in oracle?

1031

What is hash cluster in oracle?

1244

How to convert raw data type into text in oracle? Explain

1046

How to call a stored function with parameters?

1091

How to create a new table by selecting rows from another table?

1147

What is an oracle recycle bin?

1060

What is tns entry?

1234

How to retrieve the count of updated rows?

1190

What is oracle rowcount?

1143

What is a nvl function? How can it be used?

1089

How can we create the complete backup of data in the oracle.

2199

What are the different pseudo commands? Explain in general?

1121

What are the different types of synonyms?

1197

What is an oracle user role?

1036