If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 9210 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
Where is metadata stored?
What is a connected transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are ETL Tools?
What is meant by active and passive transformation?
Explain Dataware house architecture .how data flow from intial to end?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
According to his methodology what all you need before you build a datawarehouse
What do you mean by blocking transformation?
How can you validate all mappings in the repository simultaneously?
What is Session and Batches?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is meant by a domain?
Explain the shared cache and re-cache?
generate date / time dimension in informatica
