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 the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1205

How are the sources and targets definitions imported in informatica designer?

1108

What is depict expression change?

1125

Enlist some properties of sessions.

1081

What if the source is a flat-file?

1115

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1206

How to elaborate tracing level?

1182

What is meant by active and passive transformation?

1126

Explain your project of banking domian.

1653

Where is metadata stored?

1117

 Informatica Checkpoints

3334

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1071

What is intricate mapping?

1210

What is main use of mapplet?

1133

Explain pushdown optimization and types in informatica

1080