-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
sunadmn wrote:
> 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
>
Of course!
... you just have to write it
- --
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
iD8DBQFGeByTLw8L4IAs830RAp6WAJwMZmLVuZMLBBm6WcAI0XjYAzuQSQCgk/5h
8lHXoXNftyQC2NGNV+UPjBo=
=TgtC
-----END PGP SIGNATURE-----
Received on Tue Jun 19 2007 - 13:12:35 CDT
