Views

[pando]

I just did a small test

create view temp as
select ename, dname
from emp, dept
where emp.deptno=dept.deptno

then I query temp (select * from temp), then I check v$sql

it shows

sqL_text
---------------
select * from temp



Seems like the SQL that comprises the view is not cached?

[gaegoori]

I have some problem with views on my prod database. When I select * from view_name on prod, I get no rows returned, but when I run same query using same view, I get 1000 rows. Why is this happeneing to me.

[gaegoori]

sorry, I meant to say when I run the same query on my test database it retrieves 1000 rows. This is on 9.2.0.3 with Win 2000 Server.

[adewri]

Why don't you open a new thread, why replying to a two year old thread?

[sambavan]

Pando,

One other thing you want to watch out with allowing then to use views is that they don't issue any conditional clause against a view in their query. It will turn into totally a different ball game. I had some developers do that here, and complained that the database was slow.

-sam