select (case when sal is null then (select min(sal) from emp) end) from e

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

Advance Thanks

Question Posted / priyank

Answer Posted / priyank

select (case when sal is null then (select min(sal) from
emp) end) from emp

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is informatica etl tool?

987

What are the types of caches in lookup?

1035

what is Active lock explain

2773

I have a flat file, want to reverse the contents of the flat file

1109

What are batches?

1077

What are the different options available for update strategy?

990

scenario where i can use only concurrent execution of workflow.

3141

What are the prerequisite tasks to achieve the session partition?

1231

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2708

What is decode in informatica?

1123

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1263

What is the need for an etl tool?

1054

What is meant by LDAP users?

1174

Describe expression transformation?

1112

wat are deployement groups in informatica, how it will be used for developers

1701