Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select count(*) on view
On Feb 14, 6:11 am, joker197cin..._at_gmail.com wrote:
> Is it possible, according to you, that these 2 instructions:
>
> select * from view_first
>
> select count(*) from view_first
>
> where "view_first" is a view, return different rowcount?
>
> I mean that in "select * from view_first" I browse all rows through a
> GUI and I can see 200 rows but if I query the scalar value "select
> count(*) from view_first" I obtain only 150.
>
> I can't understand why...
Yes its possible.
Between the two queries if I delete 50 rows from the underlying
table, I can get your results.
There are a lot other ways I can get the results you see..
Is that what you are asking? Or do you want to be more specific?
Anurag Received on Wed Feb 14 2007 - 07:27:10 CST