update emp_test set comm=(select min(sal) from emp

If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?

Advance Thanks

Question Posted / eval

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

Please Help Members By Posting Answers For Below Questions

What is different between the data warehouse and data mart?

1108

Why is sorter an active transformation?

1191

tell me about your project functionality

2378

How would you copy the content of one repository to another repository?

1058

what is informatica metadata?

1085

What is update strategy transform?

1156

What is the session task and command task?

1106

Mention a few design and development best practices for informatica?

1042

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

2002

What are the databases that informatica can connect to windows?

1095

what is the -ve test case in your project.

2458

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1296

what is $$$$?

2198

what is the hint? how to use it to reduce the query processing in program?

7962

What is the function of union transformation?

1199