SQLPlus Mystery

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 Received on Wed Dec 16 1998 - 00:00:00 CST