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
- 10611 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
Can we override a native sql query within informatica?
How many number of sessions can one group in batches?
Name the different lookup cache(s)?
What is the difference between a repository server and a powerhouse?
tell me 5 session failure in real time how can you solve that in your project?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the sequence generator transformation in informatica?
How to load a Dimension ? and how to load a fact table?
How to load data in informatica ?
How many input parameters can exist in an unconnected lookup?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what is the -ve test case in your project.
What is the use of an aggregator cache file?
How can you differentiate between powercenter and power map?
Explain what are the different types of transformation available in informatica.
