Re: SQL help
From: Thomas Roach <troach_at_gmail.com>
Date: Mon, 23 May 2016 18:48:07 -0400
Message-ID: <CAM6TEvK+B+Q2ZMzcvnxSFPYAP7947AHCo_4GGR2BXC7Yn5JLzg_at_mail.gmail.com>
select a || chr(10) || b from test;
Date: Mon, 23 May 2016 18:48:07 -0400
Message-ID: <CAM6TEvK+B+Q2ZMzcvnxSFPYAP7947AHCo_4GGR2BXC7Yn5JLzg_at_mail.gmail.com>
select a || chr(10) || b from test;
On Mon, May 23, 2016 at 5:58 PM, Upendra nerilla <nupendra_at_hotmail.com> wrote:
> Hey guys,
> Could someone help with a SQL:
>
> I have a test table with 2 rows:
>
> create table test (a varchar2(50), b varchar2(50));
> insert into test values ('one', 'first row');
> insert into test values ('two', 'second row');
> commit;
>
> I need a query that shows the output as the following (without using
> union). Order of the values is not important.
>
> OUTPUT
> =======
> one
> first row
> two
> second row
>
> I thought unpivot might work, poked around a bit.. my brain is too tired
> to think..
>
> Thanks in advance
> -Upendra
>
-- Thomas Roach 813-404-6066 troach_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 24 2016 - 00:48:07 CEST