Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!news.tele.dk!news.tele.dk!small.news.tele.dk!news-stoc.telia.net!news-stoa.telia.net!telia.net!masternews.telia.net.!newsc.telia.net.POSTED!not-for-mail
From: "amwi" <amwi@yahoo.com>
Newsgroups: comp.databases.oracle.misc
Subject: formatting output from a column in sql plus
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <95NGc.98019$dP1.327068@newsc.telia.net>
Date: Wed, 07 Jul 2004 06:52:53 GMT
NNTP-Posting-Host: 81.226.165.132
X-Complaints-To: abuse@telia.com
X-Trace: newsc.telia.net 1089183173 81.226.165.132 (Wed, 07 Jul 2004 08:52:53 CEST)
NNTP-Posting-Date: Wed, 07 Jul 2004 08:52:53 CEST
Organization: Telia Internet
Xref: core-easynews comp.databases.oracle.misc:111518
X-Received-Date: Tue, 06 Jul 2004 23:52:03 MST (news.easynews.com)

I have read the documentation of the column command in sql plus version 10.1
and i still don't understand how to format the data field as follows.
I have tried different ways to use the column command, without success,
believe me...

Questions:
1) How to format a varchar2 field so that it is "right justified"?
2) How do i format a date field as follows 'YYYY-MM-DD' with the help of the
column command, if possible?

Thank you