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

How is union transformation utilized?

1058

What is primary and backup node?

1171

What are the different transaction levels available in transaction control transformation?

1270

What is informatica etl tool?

1055

What is transformation?

1157

What is xml source qualifier transformation in informatica?

1276

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1111

write a query to retrieve the latest records from the table sorted by version(scd)

1110

explain one complex mapping with logic? sales project?

6729

How to go to the older version for a mapping?

1152

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004

Which development components of informatica have the highest usage?

1095

What is a surrogate key?

1152

Explain the mapping variable usage example in informatica

1224

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

1077