mysqlsqlsql-servert-sqlplsql

How to create Tab Delimited Select statement?


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.


Solution

  • MySQL:

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

    SQL Server:

    select ColumnA + char(9) + ColumnB
    

    Oracle:

    select ColumnA || chr(9) || ColumnB