how to merge 3 columns from 1 table in 1 column
Not sure if this is what you meant, but you can just use a double pipe to combine them, like so…
select
ename||’:’||job||’:’|| mgr
combined_columns
from scott.emp;
From: apadukone [mailto:bounce-apadukone@toadworld.com]
Sent: Thursday, August 01, 2013 3:26 PM
Subject: [Toad for Oracle - Discussion Forum] how to merge 3 columns from 1 table in 1 column
how to merge 3 columns from 1 table in 1 column
Thread created by apadukone
how to merge 3 columns from 1 table in 1 column
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.