title: Why does Oracle View shows different output when use select * from view
body: <p>I have a View in Oracle. It's called:
  invoices</p>
  
  <p>When I call the View directly it shows me my data like this:
  select * from invoices</p>
  
  <pre><code>&gt;     +-------+------------+------------+
  &gt;     | Name  | InvoiceNo  |   Street   |
  &gt;     +-------+------------+------------+
  &gt;     | 1111  |      Peter | Pencilroad |
  &gt;     | 2222  |      Clint | Duffstreet |
  &gt;     +-------+------------+------------+
  </code></pre>
  
  <p>When I use the select statement from the view it shows me a different output:
  select epname as name, epno as invoiceno, epst as street from ep</p>
  
  <pre><code>&gt;     +-------+-----------+------------+
  &gt;     | Name  | InvoiceNo |   Street   |
  &gt;     +-------+-----------+------------+
  &gt;     | Peter |      1111 | Pencilroad |
  &gt;     | Clint |      2222 | Duffstreet |
  &gt;     +-------+-----------+------------+
  </code></pre>
  
  <p>How is this possible?
  I compiled the view again and it shows me still the different data. I also checked if the View is Invalid, but it isn't.</p>
  
  <p>Any clues? I am using SQLDeveloper on an Oracle 11g database.
  Is there also a way, to see the changes made to the view in the past or changelog with username and timestamp?</p>
  
  <p>Thanks in advance.</p>
  
  <p>Content from All_objects:</p>
  
  <pre><code>+-------+-----------------+----------------+-----------+----------------+-------------+---------------------+---------------+-----------+--------+-----------+-----------+-----------+-----------+--------------+
  | OWNER |   OBJECT_NAME   | SUBOBJECT_NAME | OBJECT_ID | DATA_OBJECT_ID | OBJECT_TYPE |       CREATED       | LAST_DDL_TIME | TIMESTAMP | STATUS | TEMPORARY | GENERATED | SECONDARY | NAMESPACE | EDITION_NAME |
  +-------+-----------------+----------------+-----------+----------------+-------------+---------------------+---------------+-----------+--------+-----------+-----------+-----------+-----------+--------------+
  | AUW   | INVOICES        |         30367  | VIEW      | 16.01.15       | 07.10.15    | 2015-10-05:13:44:13 | VALID         | N         | N      | N         |         1 |           |           |              |
  +-------+-----------------+----------------+-----------+----------------+-------------+---------------------+---------------+-----------+--------+-----------+-----------+-----------+-----------+--------------+
  </code></pre>
  
  <p>Create View statement:</p>
  
  <pre><code>CREATE VIEW INVOICES AS
  SELECT TRIM (person.NAME || NVL2 (person.Surname, ',' || person.Surname, '')) AS Name,
            RTRIM (egy.e90sart1 || egy.E90SART2) AS InvoiceNo,
            TRIM (person.street) AS Street
     FROM   person,
            egy
     WHERE      person.key = egy.key;
  </code></pre>