How to create Tab Delimited Select statement?

Question

I need to combine columns with select statment such that it create a tab delimited file.

For. e.g

Select ColumnA || "," || ColumnB

Above statement will create Comma Seperate File. What should I write to create Tab delimited file?

Please let me know.

Answer 1

MySQL:

select concat(ColumnA, "\t" ,ColumnB)

SQL Server:

select ColumnA + char(9) + ColumnB

Oracle:

select ColumnA || chr(9) || ColumnB

Answer 2

If I understand your question, you should try this:

SELECT CONCAT(ColumnA, '\t', ColumnB)