RE: Useful Oracle books - C.J. Date theory vs. practicality

From: Robson, Peter <pgro_at_bgs.ac.uk>
Date: Mon, 31 May 2004 12:05:17 +0100
Message-ID: <20F05B2143AF194CB9E300E1AEE5EF850C8ADB@mhntsmail.ad.bgs.ac.uk>

OK so far here, Dan, but it might be worth noting the count of this table just to confirm that 3 rows really were correctly inserted.

For the record, one can deal with nulls in a quasi-equivalent way by using the 'is', thus

select * from three_val_logic where test_3_val is null;

TEST_

---

1 row selected.

You might also like to consider this one, which really ices the cake, and confirms your point:

SQL> select * from three_val_logic
  2 where test_3_val != 'TRUE' and test_3_val != 'FALSE';

no rows selected

'caveat emptor', as usual....

peter
edinburgh

ps - I preferred your earlier reference to resorting to the whisky...

> -----Original Message-----
> From: Daniel Fink [mailto:Daniel.Fink_at_Sun.COM]
> Sent: Friday, May 28, 2004 9:01 PM
> To: oracle-l_at_freelists.org
> Subject: Re: Useful Oracle books - C.J. Date theory vs. practicality
>
>
> Here is sql to show the 3 valued logic in Oracle (I don't
> have nor do I want access to ProCobol to test)
>
> create table three_val_logic (test_3_val char(5));
>

<snip>

---

This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the

BGS. .                            http://www.bgs.ac.uk
*********************************************************************

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 31 2004 - 06:02:18 CDT