A Couple of Questions on Views

Question posted by: MG (Guest) on July 19th, 2005 10:40 PM

Hi,

1) Can stored procedures be used against views?

2) What are the main limitation or disadvantages of using views?

Thanks,
mohsen

Quote | Subscribe

3 Answers Posted

Tony July 19th, 2005 10:40 PM

Guest - n/a Posts

#2: Re: A Couple of Questions on Views

Join Bytes! (MG) wrote in message news:<c8e3e11c.0403022058.5da2129d@posting.google.com>...[color=blue]
> 1) Can stored procedures be used against views?[/color]

Yes
[color=blue]
> 2) What are the main limitation or disadvantages of using views?[/color]

None, as long as you use common sense. For example, if you have a
view based on the dept table with lots of joins to other tables,
aggregate functions, calls to user-defined functions, etc. then it
would be inadvisable to use it in a query like "select dname from
my_view" if all you really needed was "select dname from dept".

MG July 19th, 2005 10:40 PM

Guest - n/a Posts

#3: Re: A Couple of Questions on Views

Thanks Andrew.

Mohsen

MG July 19th, 2005 10:40 PM

Guest - n/a Posts

#4: Re: A Couple of Questions on Views

Sorry, meant to write Tony :-)

Not the answer you were looking for? Post your question . . .
197,033 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 197,033 network members.

Post your question now . . .
It's fast and it's free

Top Community Contributors

A Couple of Questions on Views

What is Bytes?

Popular Articles

Top Community Contributors