Re: SQLPlus formatting question
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 10 Jun 2005 16:37:20 -0800
Message-ID: <42aa2430_at_news.victoria.tc.ca>
Date: 10 Jun 2005 16:37:20 -0800
Message-ID: <42aa2430_at_news.victoria.tc.ca>
aldark_at_eircom.net wrote:
: Thanks very much for your help - reading up about this format modifier
: keyword - it left justifies the number in its allocated space so
: instead of being " 005.25" it becomes "005.25 " ie. with a trailing
: space, which for some reason can't be trimmed out! Any ideas?
Why not use character functions?
to_char
substr
trim
replace
index
pad
just a few that come to mind. The docs list them all.
-- This space not for rent.Received on Sat Jun 11 2005 - 02:37:20 CEST