Skip to main content

Posts

Showing posts with the label Data Types

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 = 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 ==============

Day 1: Data Types Hackerrank Solution in java

 Day 1: Data Types Hackerrank Solution Do Check My Explanation Video On Following Code: Sample Input 12 4.0 is the best place to learn and practice coding! Sample Output 16 8.0 HackerRank is the best place to learn and practice coding! Code: import  java.io.*; import  java.util.*; import  java.text.*; import  java.math.*; import  java.util.regex.*; public   class  Solution {           public   static   void  main(String[] args) {          int  i =  4 ;          double  d =  4.0 ;         String s =  "HackerRank " ;                  Scanner scan =  new  Scanner(System.in);          /* Declare second integer, double, and String variables. */          int  j = scan.nextInt();          double  d2 = scan.nextDouble();                    scan.nextLine();         String s2 = scan.nextLine();                   /* Read and save an integer, double, and String to your variables.*/          // Note: If you have trouble reading the entire String, please go back and review the Tutorial clo