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

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1774

Why update strategy and union transformations are active? Explain with examples.

1219

What all join we can perform in LOOKUP transformation?

955

Which means the first record should come as last record and last record should come as first record and load into the target file?

1059

What is a filter transformation and why it is an active one?

961

Explain scd type 3 through mapping.

964

Please let me know how to make Data masking in informatica..

1699

update strategy transformation in informatica

1052

What is Cognos script editor?

4206

How to create a non-reusable instance of reusable transformations?

1098

What are junk dimensions?

1058

If informatica has its scheduler why using third party scheduler?

1246

How do you promote a non-reusable transformation to reusable transformation?

1118

Define joiner transformation?

1029

COM components can be used in Informatica

2369