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
Explain the use of online redo log files in oracle.
Will you be able to store pictures in the database?explain.
What is oracle latest version?
Is there any function in oracle similar like group_concat of mysql?
What is transaction control statement and how many types of transaction control statement in Oracle?
What are ddl statements in oracle?
How to drop an existing table in oracle?
What are the attributes of the cursor?
How to check the oracle tns settings?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to delete a column in an existing table?
What are advantages of dateset in datastage?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What happens to the current transaction if the session is ended?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.