How do I make the delimiter a blank (no space at all) when using SQL.?

Question

I'm unloading a table within a Unix Shell Script through SQL and need the delimiter to be nothing. I want the three columns to blend together seamlessly. The reason is after the tables are unloaded we're saving them to a mainframe which needs one big long line. Any ideas? Thanks a bunch.

the table has numbers in place. when i add: Delimiter " to the end of the select line, it makes the quotation mark the delimiter. looking for now space between columns

I must not be making myself clear.
Three columns which have data:
1234 - EYE
5678 - EAR
9100 - NOSE
select EYE, EAR, NOSE Delimiter ??
from table1

What goes where the ?? are to get the result
123456789100

If you use:
select EYE, EAR, NOSE Delimiter '?'
from table1

your table would look like
1234?5678?9100
not what i want

Answer 1

If its just a blank or no space and the columns are chars then just use '' as the character delimiter. For example, if I have a column name Cust_num and some are null and blank and I want to find the ones that are blank or have no data, then I would use the SQL select * from table where cust_num='' and it would bring up all the rows where the cust_num are blank and has no data string or characters. Its just two single quotation marks.

I dont know why you need to use the delimiter if you dont want a delimiter. Just concat it depending on what SQL you are using.

Example 1:
MySQL/Oracle:
SELECT CONCAT(eye, ear, nose) FROM table1

Example 2:
Oracle:
SELECT eye || ear || nose FROM table1

Example 3:
SQL Server:
SELECT eye + ear + nose FROM table1

Answer 2

Hi Jason,

select EYE || EAR || NOSE
from table1


Good Luck,

Telco DBA
OCP - Oracle Certified Professional 9i, 10g

Database-Whitepapers: http://www.Mercury-Consulting-ltd.com/wp/whitepapers.html
Database-Checklists: http://www.IT-Checklists.com/Database_checklists.html

Answer 3

For a good time, make the delimiter a backspace.