From: andrewst@onetel.net.uk (Tony) Newsgroups: comp.databases.oracle Subject: Re: A Couple of Questions on Views Date: 3 Mar 2004 05:46:39 -0800 Organization: http://groups.google.com Lines: 12 Message-ID: References: NNTP-Posting-Host: 194.131.250.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1078321599 15969 127.0.0.1 (3 Mar 2004 13:46:39 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 3 Mar 2004 13:46:39 +0000 (UTC) deeplfo@yahoo.com (MG) wrote in message news:... > 1) Can stored procedures be used against views? Yes > 2) What are the main limitation or disadvantages of using views? 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".