Re: questions about views
- From: Stefan Kuhn <skuhn@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 16 Jul 2007 15:54:31 +0200
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@xxxxxxxxxxxx Tel. +49 (0) 345 5582 1474 Fax.+49 (0) 345 5582 1409
--
//www.freelists.org/webpage/oracle-l
Other related posts:
