Re: view as vertical concatenation of multiple tables

Thanks very much.

Tim

David Spencer <David.W.Spencer_at_oracle.com> wrote in message news:<3C3C5B5B.D3F7E9B6_at_oracle.com>...
> This works for me:
>
> insert into tab1 values('Hello');
> insert into tab2 values('Hello');
> insert into tab2 values('World');
>
> select value1 t from tab1
> union all select value2 t from tab2;
>
>
> Tim wrote:
> >
> > Hi,
> > Is it possible to create a view that is a vertical concatenation of
> > two or more tables? In other words, say you've got two tables created
> > with:
> >
> > CREATE TABLE TAB1(VALUE1 VARCHAR2(10));
> > CREATE TABLE TAB2(VALUE2 VARCHAR2(10));
> >
> > And you want a view with one column containing all the values of both
> > tables.
> > (I vaguely remember looking into this a while ago and concluding that
> > it couldn't be done, someone prove me wrong).
> > thanks,
> >
> > Tim
Received on Thu Jan 10 2002 - 05:45:07 CST