title: MINUS operation not working as expected in Stored Procedure, Oracle
body: <p>I have Oracle Stored procedure, which validates the data between two tables based on some manipulations. The Procedure has been working wrong since a recent change.(Added a new column) Not sure why is the reason. Tried to Analyses the data randomly, and we are sure there are no special characters in any of the columns.</p>
  
  <p>I copied my table's spec and recreated the scenario.</p>
  
  <p>Inserting Data</p>
  
  <pre><code> BEGIN
   FOR I IN 1..4 LOOP
    INSERT INTO AR_TABLEA VALUES('Name'||I,21+I,'Address'||I);
    INSERT INTO AR_TABLEB VALUES('Name'||I,21+I,'Address'||I);
  end loop;
   END;
   /
  </code></pre>
  
  <p>trying a MINUS operation</p>
  
  <pre><code>SELECT * FROM AR_TABLEB
  MINUS
  SELECT * FROM ar_tableA ;
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>NAME              AGE ADDRESS
  ---------- ---------- --------------------
  Name1              22 Address1
  Name2              23 Address2
  Name3              24 Address3
  Name4              25 Address4
  </code></pre>
  
  <p>But Expected Result shouldn't be "no rows selected" ?</p>
  
  <p>This is just a test data, my original tables is big enough.</p>
  
  <p>Thanks in advance, for any help!</p>