This is a question about the concatenation symbol "||"

This is a question about the concatenation symbol "||"

If i write this statement: "select
[Quoted] [Quoted] empno||','||ename||','||job||','||hiredate from emp;"

I get this output:

7369,SMITH,CLERK,17-DEC-80
7499,ALLEN,SALESMAN,20-FEB-81
7521,WARD,SALESMAN,22-FEB-81
7566,JONES,MANAGER,02-APR-81
7654,MARTIN,SALESMAN,28-SEP-81

If i write this statement: "select *|| from emp;"

I get an error.

[Quoted] The reasen why a want to write "select *||" is, that I have a table with more than 200 fields, and I need to export them all to a csv-file. I don't want to write "field1||','||field2||',' ..." for all 200 fields.

Is there a smart way to do this ???

I use SQLPlus on Oracle 9i.

Regards,
Ole Received on Sat Jul 03 2004 - 20:22:27 CEST