Welcome

Oracle SQL Tutorial

---

Oracle SQL Data Types

• NUMBER
• FLOAT
• CHAR
• VARCHAR
• VARCHAR2
• DATE
• TIMESTAMP
• INTERVAL
• LONG
• RAW
• CLOB
• BLOB
• BFILE

NUMBER DataType

NUMBER Represents Numeric value with optional scale value

• INT
• INTEGER
• SMALLINT
above three type, internally represents NUMBER(38)

NUMBER[p[,s]) represents number with precision and scale. p for precision,s for scale.

NUMBER(3) represents whole numbers ranging from -999 to 999. or with zero scale.

		create table test(
		  id number(3)
		  )
		
		Insert into table values(100);
		Insert into table values(999);
		Insert into table values(-900);
		
		

FLOAT DataType

If you don't specify precision default precision is 64.