What is the exact difference b/w IN and EXIST in Oracle..?
Answer Posted / venkateshmalneni
EXIST is used as conditional operator in which u can write a query
IN is also used as a conditional operator in which we gives a list of elements
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What do you understand by term role-playing dimension?
Define sessions in informatica etl?
can u any challenge your project?
How to generate sequence numbers?
What is informatica? Why do we need it?
How to load data in informatica ?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is workflow? What are the components of the workflow manager?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the function of union transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the types of schemas we have in data warehouse.
How to differentiate between the active and passive transformations?
whats the logic to load the lower level of granularity of data to fact table.
Which is the t/r that builts only single cache memory?