Re: view as vertical concatenation of multiple tables

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

-- 
David Spencer
www.curlypi.com