If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
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 the way to execute pl/sql script using informatica mapping?
Differentiate between a database and data warehouse?
Under which circumstances, informatica server creates reject files?
What is difference between a gateway node and worker node?
What is informatica? Why do we need it?
what is the -ve test case in your project.
How to elaborate tracing level?
On which transformations you created partitions in your project?
explain one complex mapping with logic? sales project?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to extract sap data using informatica?
What is Data Caches size?
What is the use of code page?
what is the size of your data warehousing?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks