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.
MySQL:
select concat(ColumnA, "\t" ,ColumnB)
SQL Server:
select ColumnA + char(9) + ColumnB
Oracle:
select ColumnA || chr(9) || ColumnB