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 -> append views

append views

From: Andreas Tritt <Andreas.Tritt_at_firemail.de>
Date: Wed, 30 Jul 2003 15:47:22 +0200
Message-ID: <bg8ia6$ls38a$1@ID-19075.news.uni-berlin.de>


I´ve go a problem under oracle 8.1

we have written two views

1)
create view vw141 as
select
kuno as kuno
matno as matno
YYYYMM as YYYYMM
amount as amout
from tab141

DATA
kuno matno YYYYMM amount

01    a            200301    47
02    b            200302     1

2)
create view vw142 as
select
kuno as kuno
matno as matno
YYYYMM as YYYYMM
amount as amout
from tab142

DATA
kuno matno YYYYMM amount

10    x        200301        2
12    y        200302        4

now we need to append these two views to get all Data in one view to get the following result:

DATA
kuno matno YYYYMM amount

01    a            200301        47
02    b            200302         1
10    x            200301         2
12    y            200302         4


Can someone Help please.

--
Mit freundlichen Grüßen

Andreas Tritt
Received on Wed Jul 30 2003 - 08:47:22 CDT

Original text of this message

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