How to create a tab delimited select statement?

Question

I need to combine the columns with the selected status so that it creates a tab delimited file.

For. eg

Select ColumnA || "," || ColumnB

The above instruction will create a Comma Seperate file. What should I write to create a 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 the following:

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

Answer 3

char(9) Microsoft SQL Server.

: http://msdn.microsoft.com/en-us/library/ms187323.aspx

Answer 4

Postgresql:

select concat(ColumnA, chr(9), ColumnB)