SQL Query

From: Ranjit Bajaj <ranjit.bajaj_at_NOSPAMrdel.co.uk>
Date: Thu, 24 Feb 2000 11:37:06 GMT
Message-ID: <38b517d4.1205542929_at_news.rrds.co.uk>

I'm using Oracle8i, and i'm outputting column data to a file.

I'm having problems finding a command that will left align the data by one
space on each new line of the output file.

Can anyone please help....i've looked at the COL clause but this can only be
applied to titles. Is there a way of aligning the output data by one space ?

Here is a snippet of my code:

COLUMN id HEADING 'X' FORMAT 99999;
COLUMN mode_line HEADING 'X' FORMAT 9999;

COLUMN rf_min FORMAT  9.99999999EEEE;
COLUMN rf_max FORMAT  9.99999999EEEE;
COLUMN prf_min FORMAT 9.99999999EEEE;

Thankyou Received on Thu Feb 24 2000 - 12:37:06 CET