On Monday 16 July 2007 14:22, Slawomir Cichy wrote:
> Hi Stefan
>
> Simply:
>
> create or replace view concat_eg
> as
> select field_1, field_2 from table
> union all
> select field_1, field_3 from table
dziękuję
(I vaguely remember UNION, now I finally know what it is for)
--
Stefan Kuhn BSc MA
IPB Halle
AG Bioinformatik & Massenspektrometrie
Weinberg 3
06120 Halle
http://www.ipb-halle.de http://msbi.bic-gh.de
skuhn_at_ipb-halle.de Tel. +49 (0) 345 5582 1474 Fax.+49 (0) 345 5582 1409
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 16 2007 - 08:54:31 CDT
