Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT within the FROM clause?

Re: SELECT within the FROM clause?

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Sat, 09 Sep 2006 22:34:31 GMT
Message-Id: <pan.2006.09.09.22.34.49.896498@verizon.net> 





On Sat, 09 Sep 2006 21:52:39 +0000, Dereck L. Dietz wrote:



> Okay thanks.  Would you happen to know of the top of your head if it is as

> efficient as creating an actual view to put in the query or are they about

> the same?




They're about the same. You can even name your inline view by using
subquery factoring (WITH clause).


-- 
http://www.mgogala.com


Received on Sat Sep 09 2006 - 17:34:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US