If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
Answer Posted / eval
update emp_test set comm=(select min(sal) from emp_test)
where comm is null;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
Why is sorter an active transformation?
tell me about your project functionality
How would you copy the content of one repository to another repository?
what is informatica metadata?
What is update strategy transform?
What is the session task and command task?
Mention a few design and development best practices for informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the databases that informatica can connect to windows?
what is the -ve test case in your project.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
what is $$$$?
what is the hint? how to use it to reduce the query processing in program?
What is the function of union transformation?