Re: ROWIDs in Views

From: hitman <dsagner_at_post.t-com.hr>
Date: Thu, 28 Jun 2007 00:18:00 -0700
Message-ID: <1183015080.324458.83980@q69g2000hsb.googlegroups.com>

On Jun 27, 10:45 am, "Micha" <p..._at_gmx.li> wrote:
> Some Views i have created have (internal) a rowID, others not.
> In what cases wil they create and in what cases not?

Views are just stored queries. If you select rowid from a "simple" view that has one-to-one relationship with underlying table data (keypreserved) then you wil get it. But if you try to do a select rowid from view with distinct, group by, etc you will get error: ORA-01446: cannot select rowid from view with DISTINCT...

(Cause: A SELECT statement attempted to select ROWIDs from a view containing columns derived from functions or expressions. Because the rows selected in the view do not correspond to underlying physical records, no ROWIDs can be returned. ) Received on Thu Jun 28 2007 - 02:18:00 CDT