select nvl(sal,min(sal) from <table name>

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

Advance Thanks

Question Posted / basavan

Answer Posted / basavan

Is This Answer Correct ?

1 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Explain the mapping variable usage example in informatica

1137

What is complex mapping?

1108

How do you convert single row from source into three rows into target?

1137

How can you differentiate between powercenter and power map?

1075

What is the difference between source qualifier transformations source filter to filter transformation?

1033

How we can use union transformation?

1038

What is dynamic cache?

1021

In informatics server which files are created during the session rums?

1109

What does role playing dimension mean?

1036

What is a joiner transformation?

972

What you know about transaction control transformation?

983

Explain why we use partitioning the session in informatica?

1075

What is intricate mapping?

1179

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1564

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

1939