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 -> Re: "WITH" statements and ADO...

Re: "WITH" statements and ADO...

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 27 May 2005 04:15:46 -0700
Message-ID: <1117192546.110467.150230@g14g2000cwa.googlegroups.com>


Create a view with the WITH statement and query it from your Borland compiled application:

create view T1_vw as with T1 as (select train_i from train where train_i < 20) select * from T1;

Cheers. Received on Fri May 27 2005 - 06:15:46 CDT

Original text of this message

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