Re: Formatting SQLplus output

From: Lily Djuniarti <lily.djuniarti_at_natinst.com>
Date: 21 Jul 1998 17:36:22 GMT
Message-ID: <01bdb4ce$22197bc0$370da482@tumeric.natinst.com>

Good question. :-)
it's quite a long story.

Thanks for confirming that it cannot be done with sqlplus.

-Lily
nasof_at_hotmail.com wrote in article <6p2g2h$p0g$1_at_nnrp1.dejanews.com>...
> Sounds like you need to create a PLSQL program to loop through the
results set
> and print to a file exactly what you want. I don't think you'll get a
single
> SQL statement to do this, nor a SQL*PLUS report.
>
> One question: Why in the world does someone want a flat file with pipe-
> delimited columns that are null when they are not?
>
> -Frank
>

> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Tue Jul 21 1998 - 12:36:22 CDT