RE: select question

Lisa - I liked your old signature better :).

>>> lisa.koivu_at_efairfield.com 05/31/01 03:17PM >>> I believe you'll want to rpad your return value.

select rpad(26.5,5,0) from dual

returns

26.50

or format it in SQL*Plus.

HTH
> Lisa Koivu
> Oracle Database Administrator
> 954-935-4117
>
> The information in the electronic mail message is Cendant confidential and
> may be legally privileged, it is intended solely for the addressee(s)
> access to this internet electronic mail message by anyone else is
> unauthorized. If you are not the intended recipient, any disclosure,
> copying, distribution or any action taken or omitted to be taken in
> reliance on it is prohibited and may be unlawful.
>
> The sender believes that this E-mail and any attachments were free of any
> virus, worm, Trojan horse, and/or malicious code when sent. This message
> and its attachments could have been infected during transmission. By
> reading the message and opening any attachments, the recipient accepts
> full responsibility for taking protective and remedial action about
> viruses and other defects. Cendant Corporation or Affiliates are not
> liable for any loss or damage arising in any way from this message or its
> attachments.
>
>
>
>
>
>
>
> -----Original Message-----
> From: Keith Myers [SMTP:kmyers2_at_bgnet.bgsu.edu]
> Sent: Thursday, May 31, 2001 12:22 PM
> To: Multiple recipients of list ORACLE-L
> Subject: select question
>
> I have a select statement that is pulling a field called total, which
> represents a total value to charge a persons account. The total column in
> the db has the parameters Number(10,2) but when I pull the data out of the
> db the value for the total 26.50 looks like this 26.5. Is there away to
> force the data being pulled out to maintain the format 26.50?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Keith Myers
> INET: kmyers2_at_bgnet.bgsu.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).