Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: converting data returned
On Jun 11, 3:24 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Jun 11, 3:17 pm,sunadmn<suna..._at_gmail.com> wrote:
>
>
>
> > Afternoon all,
>
> > I am trying to figure out how to some data manipulation that is
> > straight SQL and not native to SQL*Plus. I have data that returns like
> > this in a query:
>
> > PERIOD RESPONSE COUNT
> > 00 36.83333333333333333333333333333333333333 12
> > 01 42.16666666666666666666666666666666666667 12
> > 02 40.08333333333333333333333333333333333333 12
> > 03 54.83333333333333333333333333333333333333 12
> > 04 55.66666666666666666666666666666666666667 12
>
> > Now from the above I would like to just drop everything after the
> > second spot behind the decimal point but I am not sure how to do it
> > inside SQL. If I were coding this in Perl I would just use a regex or
> > something to manipulate the data the way I would like, but I am stuck
> > using the BIRT framework of Eclipse and it really only understands
> > straight SQL. Any pointers you could provide would be greqat.
>
> > Thanks a million,
> > -Steve
>
> In your SQL Manual look up the to_char, trunc, and round functions:
>
> UT1 > select to_char(9999999.99999,'9,999,999,999.99') from sys.dual;
>
> TO_CHAR(9999999.9
> -----------------
> 10,000,000.00
>
> HTH -- Mark D Powell --
Mark,
Thanks for the response here I wonder is there a function like this for dealing with non numeric data like say something like this?
WebLogic.onlinef.onlinefNET-12-7230_at_csaps012
Thanks,
-Steve
Received on Mon Jun 18 2007 - 14:27:19 CDT