Re: NewLine with SQL

On Tue, 2 Oct 2001, p.hirth_at_sbm.mc wrote:

> select "myString," || NewLine || myString2 from toto;
>
> result is : myString,
> myString2

Can't do it directly with SQL. Maybe you could add a "\n" and execute it to a file.

sqlplus xxx/yyy_at_zzz <<EOF > file1.out
select "myString,\n" || NewLine || myString2 from toto; EOF THEN cat file1.out > file2.out

The cat should notice the "\n".

Other than that, you should be able to do it in PL/SQL.

-- 
Galen Boyer
Sweet dreams and flying machines in pieces on the ground.