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
How do you migrate data from one environment to another?
What are the reusable transformations?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are roles and groups and benefits of using them?
What is the sequence generator transformation in informatica?
Define Pmrep command?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to elaborate tracing level?
What is a sorter transformation?
What is aggregate cache in aggregator transformation?
what is SDLC way of code development?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the different versions of informatica?