Re: is it possible in pl/sql?

Carel-Jan Engel wrote:
> I just created the following test:
> dgs_at_dbalert199:/opt/oracle/product/9.2.0>sqlplus '/ as sysdba'
>
> SQL*Plus: Release 9.2.0.5.0 - Production on Wed Feb 16 22:31:45 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
> With the Partitioning and Oracle Data Mining options
> JServer Release 9.2.0.5.0 - Production
>
> dbalert199.DGS.SYS SQL> create table test(c1 number);
> dbalert199.DGS.SYS SQL> insert into test values (1);
> dbalert199.DGS.SYS SQL> /
> dbalert199.DGS.SYS SQL> /
> dbalert199.DGS.SYS SQL> /
> dbalert199.DGS.SYS SQL> insert into test values (null);
> dbalert199.DGS.SYS SQL> /
> dbalert199.DGS.SYS SQL> /
> dbalert199.DGS.SYS SQL> /
> dbalert199.DGS.SYS SQL> select count(c1), count(*), count(1) from test;
>
> COUNT(C1) COUNT(*) COUNT(1)
> ========= ======== ========
> 4 8 8
>
> To see whether this has changed through history I did the very same
> test, with the very same results, on the oldest version I have
> available. :
>
> IOR: Two Process ORACLE V4.1.1 - Production
> IOR: System global area (SGA) is 15856 (16K) bytes composed of
> 1100 bytes of fixed data
> 11684 bytes of variable data,
> 1024 bytes of before image buffers, and
> 2048 bytes of buffers.
> IOR: ORACLE warm started.
>
>
>

[...]

Thanks for the update, I was wrongly confusing count(col) with count(*) in regard to null values.

Cool that you still have IOR v.4 up and running!

-Mark Bole

--
http://www.freelists.org/webpage/oracle-l