write sql query to remove null value following table
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma
i want the output
id name
101 dinesh
102 suresh
103 prakesh
- 5 Answers
- 9800 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / reddy
Hi lakshmi in filter t/r in operator not supported,
GM Answer is good
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is informatica etl tool?
What is the surrogate key?
How to load the data from people soft hrm to people soft erm using informatica?
What is fact table? Explain the different kinds of facts.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the use of an aggregator cache file?
What all are steps in up gradation of Informatica server?
explan ur project architecture?
Can we create multiple integration service on single repository?
How many number of sessions can one group in batches?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is informatica metadata?
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
Which is the t/r that builts only single cache memory?
