how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3

how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);

Question Posted / ramkrish.143

11 Answers
15637 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL ..

Answer / lavanya

suppose we hav,table name: demo
values
------
1
2
3
NULL
3
4
1
5
NULL

select values from demo where values!=NULL

Is This Answer Correct ?

0 Yes

8 No

Post New Answer

More SQL PLSQL Interview Questions

Can we call dml statement in function?

0 Answers

how to write utl file pkg in SQL

1 Answers Oracle,

Why is nosql good?

0 Answers

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers Accenture,

what is the difference between a having clause and a where clause? : Sql dba

0 Answers

What is application trigger?

0 Answers

What do you mean by query optimization?

0 Answers

Does sql view stored data?

0 Answers

What is a constraint? Tell me about its various levels.

0 Answers

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers Doyensys, Infosys, Metric Stream,

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers Polaris,

What is the difference between sql and isql*plus?

0 Answers

For more SQL PLSQL Interview Questions Click Here