Re: SQLPLUS window freezes
From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: 2000/06/27
Message-ID: <L3265.56$Pl2.34575_at_wdc-read-01.qwest.net>#1/1
Date: 2000/06/27
Message-ID: <L3265.56$Pl2.34575_at_wdc-read-01.qwest.net>#1/1
...
> As far as i know, count(*) first checks that not all columns (*) are
> null, whereas (1) can never be null.
>
> Frank
Not so, I'm afraid:
SQL*Plus > create table mikejunk (col varchar2(1));
Table created.
SQL*Plus > insert into mikejunk values (null);
1 row created.
SQL*Plus > commit;
Commit complete.
SQL*Plus > select count(*) from mikejunk;
COUNT(*)
1
SQL*Plus > select count(col) from mikejunk;
COUNT(COL)
0 Received on Tue Jun 27 2000 - 00:00:00 CEST