Re: Headings problem
From: Oracle Enterprise Internet Tools Product Management <no_replies_at_uk.oracle.com>
Date: Wed, 29 Dec 1999 08:31:24 -0000
Message-ID: <84ch2h$kqb$1_at_inet16.us.oracle.com>
Date: Wed, 29 Dec 1999 08:31:24 -0000
Message-ID: <84ch2h$kqb$1_at_inet16.us.oracle.com>
Will this do ?
SQL> create table t1 (c1 varchar2(10), c2 varchar2(10), c3 varchar2(10));
Table created.
SQL> create table t2 (header1 varchar2(10), header2 varchar2(10), header3 varchar2(10));
Table created.
SQL> insert into t1 values ('x','y','z');
1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created.
SQL> commit;
Commit complete.
SQL> select header1, header2, header3
2 from t2
3 union all
4 select c1,c2,c3
5 from t1;
HEADER1 HEADER2 HEADER3
---------- ---------- ----------
x y z x y z x y z x y z x y z x y z
7 rows selected.
-- Regards Jason ____________________________________________________________________________ __ Jason Pepper - Enterprise Internet Tools Product Management ____________________________________________________________________________ __ Opinions are mine and do not necessarily reflect those of Oracle Corporation Grzegorz Rybinski <grzegorz.rybinski_at_nokia.com> wrote in message news:OYl84.106$Lx3.4488_at_news2.nokia.com...Received on Wed Dec 29 1999 - 09:31:24 CET
> Hi,
> I have a following problem: I have 2 tables. In first one I have data but
it
> real field headings are in second table
> DATE_FIELD1
> DATE_FIELD2
> DATE_FIELD3
> ETC....
> In the second table I have real (shown in a appplication) headings for the
> fileds names from first table:
> DATE_FIELD1_HEADER
> DATE_FIELD2_HEADER
> DATE_FIELD3_HEADER
> I need a view which will contain field names from second table but data
from
> from the first. There is PF_FK relation between tables.
> Thanx
> Gregory
>
>