Home » SQL & PL/SQL » SQL & PL/SQL » dollar amount data type
dollar amount data type [message #270649] Thu, 27 September 2007 13:39 Go to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
Hi
is there any dollar amount data type in oracle other than number or integer data type.Thanks for the help.
cheers
ryju
Re: dollar amount data type [message #270650 is a reply to message #270649] Thu, 27 September 2007 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
no such datatype
Would you also like yen, peso, pound, dinar datatypes?
Re: dollar amount data type [message #270652 is a reply to message #270649] Thu, 27 September 2007 13:43 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
yes.I like all currency data type.Many thanks
Re: dollar amount data type [message #270653 is a reply to message #270650] Thu, 27 September 2007 13:45 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
actually i am looking for a best data type for currencies.Which is best?
Re: dollar amount data type [message #270654 is a reply to message #270652] Thu, 27 September 2007 13:45 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
You are thinking format not datatype. look at the to_char function to display a numerical data type in a specific format.
P.S. Fear not anacedent, I got your sarcasm Wink
Re: dollar amount data type [message #270657 is a reply to message #270654] Thu, 27 September 2007 13:47 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
what does that mean? sarcasm?
Re: dollar amount data type [message #270659 is a reply to message #270657] Thu, 27 September 2007 13:48 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Don't worry about it mate Thumbs Up
Re: dollar amount data type [message #270663 is a reply to message #270649] Thu, 27 September 2007 13:50 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
ok.Thanks for the clue.
Re: dollar amount data type [message #270665 is a reply to message #270663] Thu, 27 September 2007 13:51 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
No Problem. Post back if you have problems
Re: dollar amount data type [message #270807 is a reply to message #270654] Fri, 28 September 2007 01:26 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
pablolee wrote on Thu, 27 September 2007 20:45
You are thinking format not datatype. look at the to_char function to display a numerical data type in a specific format.
Good advice! Here's a link to the numeric format models.

MHE
Previous Topic: Oracle 10G Compliance
Next Topic: Please Help Me with Select ... Into Statement (PLS-00428)
Goto Forum:
  


Current Time: Thu Dec 08 18:04:37 CST 2016

Total time taken to generate the page: 0.07269 seconds