Re: SQLPlus Mystery

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