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
- 8787 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
Hi Srinivas how the sql query execute because the query
returns only max values.. so please clarify.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Sequence generator, when you move from develoment to production how will you reset
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain in detail about scd type 1 through mapping.
How can you generate reports in informatica?
When do you use sql override in a lookup transformation?
where to store informatica rejected data?
What are the types of presistent cache in look up tr.
How can we use batches?
What is data caches/ index caches?
What is a node in Informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What does cheating measurement mean?
Tell me about MD5 functions in informatica
To import the flat file definition into the designer where should the flat file be placed?
How can we improve session performance in aggregator transformation?
