Skip to main content

Posts

Showing posts with the label Oracle Supporting Data Types With Examples

Oracle Supporting Data Types With Examples

 *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 ...