Interested to Buy Any Domain ? << Click Here >> for more details...
If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 10308 Views
- Puma, I also Faced
- E-Mail Answers
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
What is meant by active and passive transformation?
Design time, run time. If you don't create parameter what will happen
Separate from a database, an information bazaar, and an information stockroom?
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)
What are the new features of informatica 9.x in developer level?
Reusable transformation and shortcut differences
what is the -ve test case in your project.
What is substr in informatica?
What is meant by lookup transformation?
What are junk dimensions?
update strategy transformation in informatica
What is the commit type if you have a transaction control transformation in the mapping?
Separate from an archive server and a powerhouse?
is it possible to index the data in cache of lkp transformation ?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
