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 / abc

Answer Posted / abc

update emp_test set comm=(select min(sal) from emp_test)
where comm is null;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sq transformation?

687

How do you manage the Parameter files while migrating your data from one environment to another environment?

577

Can we change Dynamic to Static or Persistent cache? If so what happens?

1745

Differences between connected and unconnected lookup?

631

4 yrs etl devloper roles and responsibilities?any body give solutions

1600

Explain the scenario which compels informatica server to reject files?

670

Explain how many types of dimensions are available in informatica?

612

what is unit testing?tell me proceedure

1801

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7789

What is meant by active and passive transformation?

607

How many ways are there to do 'remove duplicate records in informatica'?

597

What is source qualifier transformation in informatica?

590

What if the source is a flat-file?

607

Differentiate between router and filter transformation?

630

How to implement security measures using repository manager?

625