Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Corporate Acceptance of Creating Views ?
"jane" <janeyiu_at_optonline.net> wrote in message
news:eQoD7.43362$C7.13166440_at_news02.optonline.net...
> Is it true that in general corporate enviornment, the use of Views is
> discouraged ? even frowned up ?
No it is not true.
> I was working with this "seasoned" developer on developing reports, I am
new
> to the Oracle enviornment
> and she insisted that I should NOT use views if at all possible,
preferablly
> not at all.
>
> "You should be able to get all the data you need with straight SQL...even
if
> it have to go for pages !"
> "...you are creating yet another dependency...it's another object that has
> to be maintained !......"
>
> The thing was with tools like Crystal Reports, it does not handle manual
SQL
> very well (requires
> a separate file to store the query)
>
> Is this true ? Was she full of bs ?
Yes and No.
A view is a bad idea if you are trying to create it as a substitute for writing SQL codes in *one* report.
A view is a good idea if you are trying to implement reusable codes.
Roel Received on Tue Oct 30 2001 - 16:25:46 CST