CODE EXAMPLE FOR SQL

how to merge to coloumns into a single column with a space.

Select column1||' '||column2 from table_name;