Re: How do I Insert newlines between columns

From: Fred Ruffet <fruffet_at_kaptech.com>
Date: Wed, 26 May 1999 13:45:33 +0200
Message-ID: <7igmt4$46c$1@gatekeeper.ornano.kapt.com>

The only way I know for you to do this would be to create a PL/SQL = procedure that prints the output you want (with DBMS).

Regards,

Fred
Keith Jamieson a écrit dans le message = <374BD061.BB003165_at_email.mot.com>...

    I have an SQL statement as follows:     select column_a,

              column_b 
              column_c 

    from table_name etc.
    I would like to format the output so that it appears as follows:     

    columna
    columnb
    columnc     

    So, I need to concatenate the newline command. (\n) at the end of = the first two columns.

    The problem is that if I just coincatenate the newline command, the = output I get is

    just columna\n columnb\n columnc\n.     Does anyone know how I can achieve this?

Received on Wed May 26 1999 - 06:45:33 CDT