Numeric Datatype

By default: The precision p can range from 1 to 38 The scale s can range from -84 to 127  A NUMBER value requires from 1 to 22 bytes Requirements Precision: number of digits the computer has to store Scale: Number of digits after decimal For example, if we look at 12345.67 Precision = 7 Scale = 2   Example […]

Numeric Datatype Read More »


Character Data Types CHAR VARCHAR TEXT Numeric Data Types INT DECIMAL FLOAT Date and Time Data Types DATE TIME TIMESTAMP Boolean Data Type BOOLEAN Binary Data Types BINARY VARBINARY BLOB Other Data Types ENUM JSON GEOMETRY 1. Character Data Types CHAR The CHAR data type is used to store fixed-length character strings. For CREATE TABLE

DataTypes Read More »

Scroll to Top