OraFAQ Forum: SQL & PL/SQL » using VIEW in procedures

Home » SQL & PL/SQL » SQL & PL/SQL » using VIEW in procedures (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using VIEW in procedures [message #628768]

Fri, 28 November 2014 05:28

live4learn
Messages: 41
Registered: September 2013
Location: Bangalore, India

Member

As we know the view is getting evaluated at the time the view is queried. Just wondering ,If I use a view in a procedure multiple times in select statement ,do the underlying view definition query will be executed each time or the view retain in buffer till the procedure session is active ?

Report message to a moderator

Re: using VIEW in procedures [message #628769 is a reply to message #628768]

Fri, 28 November 2014 05:36

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

View is simply a stored query, nothing more. Querying a view multiple times is exactly the same as the running the query the view is based on multiple times.

Report message to a moderator

Re: using VIEW in procedures [message #628815 is a reply to message #628769]

Fri, 28 November 2014 09:57

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

View is simply a stored query, nothing more

A stored query text to be even clearer. Smile

Report message to a moderator

Previous Topic:	Getting the Minimum of a date column
Next Topic:	Split 1 row into multiple based on date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 09:29:15 CDT 2024