UNION UNION ALL MINUS INTERSECT

What are set operators in Oracle

Question Posted / parameswarareddy

Answer Posted / parameswarareddy

UNION
UNION ALL
MINUS
INTERSECT

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

write a query to retrieve the latest records from the table sorted by version(scd)

1068

What is a predefined event?

1093

What is status code in informatica?

1020

On which transformations you created partitions in your project?

1347

State the differences between sql override and lookup override?

1208

Partition, what happens if the specified key range is shorter and longer

2499

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900

Briefly describe lookup transformation?

1046

What is meant by query override?

1059

Different sorts of metadata that stores in the storage facility?

1011

Repository user profiles

1762

What are roles and groups and benefits of using them?

1057

What is a node in Informatica?

1041

Tell me about Propagate functions in informatica

922

Describe the impact of several join conditions and join order in a joiner transformation?

1063