What are set operators in Oracle

Answer Posted / dl

fOLLOWING are the set operators in oracle
UNION
UNION ALL
MINUS
INTERSECT

Is This Answer Correct ?    67 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update source definition?

634


What is the Rank index port in Rank transformation?

672


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1679


Global and Local shortcuts. Advantages.

1472


What is an expression transformation in informatica?

519






What is the difference between a repository server and a powerhouse?

818


What are different types of transformations available in informatica?

588


Define mapping and session?

587


Explain the difference between mapping parameter and mapping variable?

606


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5261


What is transformation?

661


Please let me know how to make Data masking in informatica..

1271


Does an informatica transformation support only aggregate expressions?

608


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

642


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1626