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

whats the logic to load the lower level of granularity of data to fact table.

2276

How to elaborate tracing level?

1181

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2078

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1786

Different circumstance which drives informatica server to expel records?

985

Enlist some properties of sessions.

1081

Explain sessions. Explain how batches are used to combine executions?

1034

which one is better performance wise joiner or look up

1095

What are the limitations of joiner transformation?

1114

How you can differentiate between connected lookup and unconnected lookup?

1064

What is session task and command task?

1302

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

1000

How to load last n records of file into target table - informatica

1083

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710

What is rank transformation?

991