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 ?
>
> 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 ?
>
> thanks
> jane
>
>

No she wasn't full of bs. Her obvious concern was you were going to create individual views for individual reports. As views nowadays have to be compiled (a select * is resolved at compile-time, not at run-time) her concern about another level of dependency is correct.

Hth,

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address