Interested to Buy Any Domain ? << Click Here >> for more details...
If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 10523 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / amol m
SELECT DECODE(w.salary,NULL,(SELECT MIN(e.salary) FROM
employees e),w.salary) FROM employees w
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is unit testing?tell me proceedure
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is primary and backup node?
What is an expression transformation?
Explain how to import oracle sequence into informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is size of u r database?
What is the maplet?
Quickly characterize reusable change?
Define the various join types of joiner transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is domain in terms of informatica?
What is joiner transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
