Home » RDBMS Server » Server Administration » Re: count number of nulls in column for each row
Re: count number of nulls in column for each row [message #370797] Wed, 09 February 2000 02:40
Atavur Rahaman
Messages: 1
Registered: February 2000
Junior Member
Hello Kurkj,

Good Day!..

I think this will also works.......

SQL> Select Id,Decode(Col1,NULL,1,NULL) COLUMN1,
Decode(Col2,NULL,1,NULL) COLUMN2, Decode(Col3,NULL,1,NULL) COLUMN3, Decode(Col4,NULL,1,NULL)COLUMN4 From Table_Name;

And by using Table Alias Names we can also proceed....

Regards
Atavur Rahaman S.A
Previous Topic: Re: URGENT Syntax question Dynamic SQL.
Next Topic: REF and MULTISET
Goto Forum:
  


Current Time: Fri Oct 30 02:33:44 CDT 2020