SQL*PLUS simple quesion

[Quoted] What we want to do is the following:

We want our select statement to return the output in csv format i.e :

field1,field2,field3

The select statement we've tried was select field1 || ',' || field2 || ',' || field3, which works out ok except for one thing.

The header returned was "field1||','||field2||',' etc..

How do we make the heading look correkt i.e. field1,field2,field3

[Quoted] [Quoted] another question: Is there a method to avoid the "N rows selected" , which is [Quoted] [Quoted] very annoying if you want to automatically process the output.

-- 
[Quoted] Venlig hilsen

Henning Lang - Systemadministrator

Erhvervsskolen Hamlet
IT afdelingen
Milnersvej 48
3400 Hillerød

tlf: 48 29 01 23 / 24 86 99 04
hlang_at_mail.htc.dk