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 a sorter transformation?

1095

Where can we find the throughput option in informatica?

1057

What are the differences between source qualifier and joiner transformation?

1051

What is a surrogate key?

1074

How to Create a folder using pmrep command?

1170

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1075

How many numbers of sessions can one group in batches?

1060

Explain the different dimensions.

954

Why is sorter an active transformation?

1115

What are the new features of informatica 9.x in developer level?

988

What is data movement mode in Informatica and difference between them?

1127

What is sequence generator transformation in informatica?

1067

What is an Integration service in Informatica?

1128

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2129

What are the guidelines to be followed while using union transformation?

1134