Hi Ramkrish, select *from k; SNO ----- 1 2 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 / srinu

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

Answer Posted / srinu

Hi Ramkrish,

select *from k;

SNO
-----
1
2
3

3
4

9 rows selected

select sno from k where sno is not null;

SNO
-----
1
2
3
3
4

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a clob in sql?

1026

What is the difference between the conventional and direct path loads? : aql loader

1401

What company owns postgresql?

1033

Can you join a table to itself?

1133

How do you write a subquery?

1032

How does sql*loader handles newline characters in a record? : aql loader

1047

List the ways to get the count of records in a table?

900

Can a table have no primary key?

1065

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2085

Can we create foreign key without primary key?

987

What are triggers in sql?

1023

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1018

What does count (*) mean?

936

What is scalar function?

1058

What does count (*) do in sql?

1017