If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
Answer Posted / madhu
here is the query
update emp set sal =(select min(sal) from emp) where sal is null
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Describe an informatica powercenter?
What do think which one is the better joiner or look up?
How can we create index after completion of load process?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
In which transformation you cannot drag ports into it?
What are the different components of powercenter?
What is the procedure for creating independent data marts from informatica 7.1?
What is aggregator transformation in informatica?
What do you mean by enterprise data warehousing?
Explain in detail about scd type 1 through mapping.
How can we handle two sessions in informatica?
What are connected or unconnected transformations?
How do you load only null records into target? Explain through mapping flow.
In informatica workflow manager, how many repositories can be created?
is it possible to index the data in cache of lkp transformation ?