write a query to remove null value follwing table?
col1 col2 col3
dinesh null null
null suresh null
null null prakesh
i want the output
col1 col2 col3
dinesh suresh prakesh
- 4 Answers
- 8444 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / srinivas kondeti
SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How to handle decimal places while importing a flatfile into informatica?
How to use pmcmd utility command?
Define update strategy?
What are the advantages of informatica?
Explain dynamic target flat file name generation in informatica
What is dimensional table?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Where can we find the throughput option in informatica?
What is Data Caches size?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is meant by incremental aggregation?
What is meant by active and passive transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the designer tools for creating transformations?
What is the session task and command task?
