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

Home -> Community -> Usenet -> c.d.o.misc -> Dynamic Views was(Selects in From clause)

Dynamic Views was(Selects in From clause)

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: Tue, 19 May 1998 17:02:48 GMT
Message-ID: <mjrEt7rCp.4Fv@netcom.com> 





In article <mjrEt2vxJ.Er_at_netcom.com>, Mark Rosenbaum <mjr_at_netcom.com> wrote:


>Anyone using select in from clauses? I'm using Oracle 7.3.3.4.1


>on HPUX 11 and am hitting some bugs? Anyone else?


>


>tia


>


>mjr





Sorry for the confusion an example would be



select * from 


(select rownum from user_tables where rownum < 17) a
(select rownum from user_tables where rownum < 17) b
where a < b;



tia



mjr
Received on Tue May 19 1998 - 12:02:48 CDT












Original text of this message













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