Re: SQLPlus Mystery

Afraid I know nothing about SQLWorksheet, but is it possible that it treats nulls differently from SQLPlus? Count(*) will include rows which are null

fumi wrote:
>
> Tansel Ozkan ¼¶¼g©ó¤å³¹ <759brn$t8e_at_enews4.newsguy.com>...
> >We are having a strange problem:
> >The same query is returning different number of records when
> >run from SQLPlus and SQLWorksheet. The SQL statement below
> >is returning 180 records when run from SQLPlus, and 194 records
> >from SQLWorksheet.
> >
> >select a.doc_id||'|'||a.doc_title||'|'||b.stock_qty||'|'||
> >b.committed_qty||'|'||a.reorder_qty||'|'||a.samp_cutoff_qty
> >from documents a,doc_stock b, doc_int_mapping c
> >where a.doc_id=b.doc_id and
> >b.doc_id=c.doc_id and
> >c.int_code='PACK'
> >
> >The interesting is that if I run the same query from SQLPlus
> >with count(*) instead of a select field, I get the same number of records
> >as run from SQLWorksheet.
> >
> >select count(*)
> >from documents a,doc_stock b, doc_int_mapping c
> >where a.doc_id=b.doc_id and
> >b.doc_id=c.doc_id and
> >c.int_code='PACK'
> >
> >Any ideas to help me solve this mystery?
> >
> >Tansel
>
> Are you sure there was nobody inserted data (and committed)
> during the first two executions in SQL*Plus and in SQL Worksheet?
Received on Fri Dec 18 1998 - 00:00:00 CST