Re: SQLPlus Mystery

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: 1998/12/21
Message-ID: <75lii9$ail$1@news.seed.net.tw>#1/1

Rick ¼¶¼g©ó¤å³¹ <367A2A7C.187D_at_nospam.btinternet.com>...
>Afraid I know nothing about SQLWorksheet, but is it possible that it
>treats nulls differently from SQLPlus? Count(*) will include rows
>which are null

It can't happen.

SQL*Plus and SQL Worksheet are just "TOOLS". They don't participate the internal engine of Oracle. Image that, if what you said is true, it's too horrendous. We may be anxiety and skeptical that whether the same SQL statements in VB, VC++, Delphi... will alway get the same results. We may waste tremendous time in debuging and verifying the results. Received on Mon Dec 21 1998 - 00:00:00 CST