Re: Corporate Acceptance of Creating Views ?
Date: Tue, 30 Oct 2001 22:25:46 GMT
Message-ID: <KNFD7.90249$WW.4999835_at_bgtnsc05-news.ops.worldnet.att.net>
"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 - 23:25:46 CET