DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:from;
        b=Wpq5G0BA6RwrAbY0qLoF0Pee+Skm+2EbdNB2OvHXWO8dLsl/iQFM87VauxdZCxhFk7xLuav/TFf8uY7vnCpBWrXGW4b6jJ9UX743y9/66/Cd4nHgW1jWayfC5xd5gCGHyub9dI4eIu/ShcoPtQAogvGwwyw80nqklwf9ssgTYdo=
Message-ID: <469BD23C.7030802@inbox.lv>
Date: Mon, 16 Jul 2007 13:17:00 -0700
User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
MIME-Version: 1.0
To: skuhn@ipb-halle.de
CC: oracle-l@freelists.org
Subject: Re: questions about views
References: <200707161059.32068.skuhn@ipb-halle.de> <7765c8970707160422s7b68590bg856ff59f2b5d91b6@mail.gmail.com> <200707161337.37893.skuhn@ipb-halle.de>
In-Reply-To: <200707161337.37893.skuhn@ipb-halle.de>
Content-Type: multipart/alternative; boundary="------------080201080205020600050802"
From: GovindanK <gkatteri@gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: gkatteri@gmail.com
--------------080201080205020600050802
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Stefan
 
You would need to do as follows
*column seq2 noprint;
select 1  seq1 , 1 seq2 , column_a from table1
union
select 1  seq1 , 2 seq2 , column_b from table1
union
select 2  seq1 , 1 seq2 , column_c from table2
union
select 2  seq1 , 2 seq2 , column_d from table2
order by seq , seq2
/

*Hope this answers your question.

GovindanK

> Ok, I didn't express well what I want to do. I want to put one table after the 
> other. So the original table is
> 1 a b
> 2 c d
> I want
> 1 a
> 1 b
> 2 c
> 2 d
> in the view.
> Thanks for answering.
> Stefan
>   


--------------080201080205020600050802
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Stefan<br>
 <br>
You would need to do as follows<br>
<b>column seq2 noprint;<br>
select 1  seq1 , 1 seq2 , column_a from table1<br>
union<br>
select 1  seq1 , 2 seq2 , column_b from table1<br>
union<br>
select 2  seq1 , 1 seq2 , column_c from table2<br>
union<br>
select 2  seq1 , 2 seq2 , column_d from table2<br>
order by seq , seq2<br>
/<br>
<br>
</b>Hope this answers your question.<br>
<br>
GovindanK<br>
<br>
<blockquote cite="mid:200707161337.37893.skuhn@ipb-halle.de" type="cite">
  <pre wrap="">Ok, I didn't express well what I want to do. I want to put one table after the 
other. So the original table is
1 a b
2 c d
I want
1 a
1 b
2 c
2 d
in the view.
Thanks for answering.
Stefan
  </pre>
</blockquote>
<br>
</body>
</html>

--------------080201080205020600050802--
--
http://www.freelists.org/webpage/oracle-l