Re: Views

This is what the view is doing:

What is coming back incorrectly, is the addr.FORMAT as Addr_Format information. What is seen in the view is different than what is actually in the ADDRESSES table.

CREATE OR REPLACE VIEW V_RPT_CONTACT_ADDRESS_PHONE ( ID, POPCODE, OWNER, CONTACT_FORMAT, TITLE,
CONTACT_TYPE, CONTACT_DESC, NOTES, PHONE_FORMAT, EXTENSION, COMMENTS, PHONE_TYPE, ADDR_FORMAT, STREET, ADDR_DESC, FLOOR, SUITE,
CITY, STATE, ZIP ) AS select

contact.ID,                              -- contacts
contact.popcode,
contact.owner,                           -- varchar2(20)
contact.FORMAT as Contact_Format,
contact.TITLE,                                    -- varchar2(50)
contact.TYPE as Contact_Type,                     -- varchar2(50)
contact.DESCRIPTION as Contact_Desc,        -- varchar2(50)
contact.NOTES,                                 -- varchar2(2000)
phone.FORMAT as Phone_Format      ,               -- varchar2(50)
phone.EXTENSION    ,                              -- varchar2(4)
phone.COMMENTS     ,                              -- varchar2(50)
phone.TYPE  as Phone_Type       ,                 -- varchar2(20)
addr.FORMAT as Addr_Format       ,                -- varchar2(50)
 addr.STREET        ,                             -- varchar2(128)
addr.DECRIPTION as Addr_Desc   ,                  -- varchar2(50)
addr.FLOOR         ,                             -- varchar2(50)
addr.SUITE         ,                             -- varchar2(50)
addr.CITY          ,                             -- varchar2(50)
addr.STATE         ,                             -- varchar2(50)
addr.ZIP                                          -- varchar2(50)

from contacts CONTACT, PHONENUMBERS PHONE, ADDRESSES ADDR WHERE PHONE.OWNER = CONTACT.NAME_ID
AND ADDR.OWNER = CONTACT.NAME_ID Steve McDaniels wrote:

> Is the data changed or is the ORDER of the data is changed?
>
> null <null_at_yahoo.com> wrote in message news:386115C4.1B4AC519_at_yahoo.com...
> > Running Oracle 8.0.5.2 on Solaris 2.7
> > There is a view created that accesses data from a particular table.
> > However, when querying the actual table the data comes back differently
> > than what results when querying the actual view.
> > I'm not sure what would cause this, and would appreciate any ideas or
> > suggestions.
> >
> > Thanks in advance.
> >
> >
Received on Wed Dec 22 1999 - 00:00:00 CST