If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 9211 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / abc
update emp_test set comm=(select min(sal) from emp_test)
where comm is null;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can anyone tell me the new features in Informatica 9 Version?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the difference between a repository server and a powerhouse?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
To import the flat file definition into the designer where should the flat file be placed?
what is the hint? how to use it to reduce the query processing in program?
Explain Dataware house architecture .how data flow from intial to end?
According to his methodology what all you need before you build a datawarehouse
Have you worked with/created Parameter file
Is stop and abort are same in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to load last n records of file into target table - informatica
What is fact table? Explain the different kinds of facts.
how many types of dimensions are available in informatica?
Which is the t/r that builts only single cache memory?
