*Oracle Supporting Data Types 1)Numeric Datatypes 2)Character/string 3)Long 4)Date 5)Raw & Long Raw 6)Lob (Large Object) ========================================================================= 1)Numeric DT: ============ i)INT ii)Number i)INT: =>To store Integer values Only =>when we use "int" DT at the time of table designing internally Oracle Server is converting into "Number" DT with max size 38 Digits. int = Number(38) ii)Number(p,s): =>To store Integer and float value >Number(p) --------->INT >Number(p,s)--------->Float Precision(p): ============= =>Counting all digits (left + right) in the given Expression ex:: i)98.34 precision = 4 ii)9878.34 precision = 6 scale(s): ========= =>Counting right side digit Only ex:i)98.34 precision = 4 scale = 2 ii)8870.454 precision = 7 scale = 3 2)Character/string DT ==============