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
- 10606 Views
- Puma, I also Faced
- E-Mail Answers
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
How to create or import flat file definition in to the warehouse designer?
What are the new features of informatica 9.x at the developer level?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is substr in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is Active lock explain
Explain in detail about scd type 1 through mapping.
Explain lookup transformation in informatica
What is informatica powercenter repository?
How you prepared reports for OLAP?
What is a node in Informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is workflow manager?
What is meant by query override?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
