If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
Answer Posted / priyank
select (case when sal is null then (select min(sal) from
emp) end) from emp
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What you know about transaction control transformation?
What are connected or unconnected transformations?
What is event and what are the tasks related to it?
What is target designer and target load order?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is the size of u r source(like file or table)?
can we override a native sql query within informatica? How do we do it?
Differences between connected and unconnected lookup?
How can you define user defied event?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain the tuning lookup transformation - informatica
Enlist some properties of sessions.
What is decode in static cache?
What are the different types of repositories created using informatica?