How to merge (combine) 2 columns into 1 in oracle?

merge, oracle, sql

Solution

concatenate?

select col1 || ' ' || col2 from tablex

Problem

I have 3 textfields where user types table name and 2 column names which need to be merged. How should I merge (combine) 2 column values into 1? I use oracle 11g enterprise

Original source

Related problems