Home » SQL & PL/SQL » SQL & PL/SQL » how -ve scale is used in number datatype??
icon9.gif  how -ve scale is used in number datatype?? [message #215291] Sat, 20 January 2007 11:29 Go to next message
raje.vinayak
Messages: 10
Registered: January 2007
Location: thane
Junior Member
Dear all,

in number datatype we specify precision and scale
precision is 1-38 and scale is -84 to 127

would u plz explain me when and how -ve scale is used
i will be glad if u explain with examples


thanking you

vinayak
Re: how -ve scale is used in number datatype?? [message #215294 is a reply to message #215291] Sat, 20 January 2007 12:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
I hope are willing to read the fine Concept Manual found at http://tahiti.oracle.com specifically
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/datatype.htm#sthref3811
icon6.gif  Re: how -ve scale is used in number datatype?? [message #215523 is a reply to message #215294] Mon, 22 January 2007 12:47 Go to previous message
raje.vinayak
Messages: 10
Registered: January 2007
Location: thane
Junior Member
Dear frnd,

Thanx for u r kind help
URL send by u GOnna help me very much

thanks again


keep in touch
Previous Topic: Publishing PL/SQL as web service
Next Topic: Good SQL statement
Goto Forum:
  


Current Time: Sat Dec 10 16:58:56 CST 2016

Total time taken to generate the page: 0.04246 seconds