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 -> Is this possible in oracle

Is this possible in oracle

From: <nekkalapudi.siva_at_gmail.com>
Date: 27 Mar 2005 05:56:47 -0800
Message-ID: <1111931807.567496.56600@f14g2000cwb.googlegroups.com>


I have the following query

SELECT t1.*
FROM t1
UNION ALL
SELECT t2.*
FROM t2

Now the question is can we display T1 data first and then T2 data next with out using UNION ALL Received on Sun Mar 27 2005 - 07:56:47 CST

Original text of this message

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