If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
Answer Posted / eval
update emp_test set comm=(select min(sal) from emp_test)
where comm is null;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Different circumstance which drives informatica server to expel records?
What is enterprise data warehousing?
Describe data concatenation?
Different sorts of metadata that stores in the storage facility?
tell me 5 session failure in real time how can you solve that in your project?
Explain sql transformation in script mode examples in informatica
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
Repository user profiles
How can we remove the duplicates from flat file source?
How do you load first and last records into target table?
Is there any target staging area in informatica not staging area
Explain sessions and how many types of sessions are there?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Enlist few areas or real-time situations where informatica is required.
What are the different versions of informatica?