SELECT a || CHR(10) || b FROM test;
On May 23, 2016, at 5:58 PM, Upendra nerilla <nupendra@xxxxxxxxxxx> 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