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
- 10800 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
Explain the different kinds of facts.
What is option by which we can run all the sessions in a batch simultaneously?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Describe data concatenation?
What are mapplets? How is it different from a Reusable Transformation?
How to create the source and target database connections in server manager?
How can we improve session performance in aggregator transformation?
What is target load order?
How will the document be delivered to me?
explan ur project architecture?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is difference between a gateway node and worker node?
Define joiner transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What does “tail –f” command do and what is its use as an Informatica admin.
