Toad World® Forums

how to merge 3 columns from 1 table in 1 column


#1

how to merge 3 columns from 1 table in 1 column


#2

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

To: toadoracle@toadworld.com

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.