|
|
|
|
|
|
|
Re: NOT NULL columns count [message #317341 is a reply to message #317338] |
Wed, 30 April 2008 14:08   |
saiphani723
Messages: 38 Registered: July 2006 Location: Hyderabad
|
Member |
|
|
i tried in the following way
my screen capturing is not working. becuase of that i copied and paste hee
SQL> select nvl2(empno,1,0)+nvl2(ename,1,0)+nvl2(job,1,0)+nvl2(sal,1,0)+nvl2(comm,1,0)+nvl2(deptno,1
,0) from emp;
NVL2(EMPNO,1,0)+NVL2(ENAME,1,0)+NVL2(JOB,1,0)+NVL2(SAL,1,0)+NVL2(COMM,1,0)+NVL2(DEPTNO,1,0)
-------------------------------------------------------------------------------------------
5
6
6
5
6
5
5
5
5
6
5
5
5
5
14 rows selected.
|
|
|
|
Re: NOT NULL columns count [message #317344 is a reply to message #317342] |
Wed, 30 April 2008 14:15   |
saiphani723
Messages: 38 Registered: July 2006 Location: Hyderabad
|
Member |
|
|
Result is correct. but i think that is not the correct way of doing. For some columns it is ok. If there are more than 50 columns in that case i think it is bit difficult.
|
|
|
Re: NOT NULL columns count [message #317347 is a reply to message #317344] |
Wed, 30 April 2008 14:59  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
This is the fastest way.
You can find more complex ones but there are not slower and will not let you type less characters.
Regards
Michel
|
|
|