Re: Corporate Acceptance of Creating Views ?
Date: Tue, 30 Oct 2001 09:34:58 +0100
Message-ID: <ttspeo9frv6h80_at_corp.supernews.com>
"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 addressReceived on Tue Oct 30 2001 - 09:34:58 CET