Re: SQL*PLUS simple quesion
From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 6 Dec 2000 14:26:56 +0100
Message-ID: <90leti$sa7$1_at_s1.read.news.oleane.net>
Date: Wed, 6 Dec 2000 14:26:56 +0100
Message-ID: <90leti$sa7$1_at_s1.read.news.oleane.net>
[Quoted] Answer embedded.
-- [Quoted] Have a nice day Michel Henning Eli Lang <hlang_at_mail.htc.dk> a écrit dans le message : 3A2E11DB.DAE9E2DB_at_mail.htc.dk...Received on Wed Dec 06 2000 - 14:26:56 CET
> 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
select field1 || ',' || field2 || ',' || field3 as "field1,field2,field3" from ...
>
> another question: Is there a method to avoid the "N rows selected" , which is
> very annoying if you want to automatically process the output.
set feedback off
>
>
> --
> 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