Why Does A/C Return Few Records Than 'SHOW SQL' Per TOAD? (Doc ID 2048398.1)

Last updated on OCTOBER 28, 2015

Applies to:

Oracle Argus Safety - Version 7.0.2 and later
Information in this document applies to any platform.

Goal

Problem Description
---------------------------------------------------
Built an Advance Condition and generated it from ARGUS it returned 1800 records.
Then copied SQL from 'Show SQL' window in ARGUS A/C screen into Oracle SQL/Plus or Toad and it returned 2243 records.

How it is possible? And why we are seeing different results?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms