DATA TYPES THAT A CELL CAN HOLD

DATA TYPES THAT A CELL CAN HOLD

Data Types:-

CHAR (Size):- This data type is used to store character strings values of fixed length. The size in brackets determines the number of characters the cell can hold. The maximum number of characters this data type can hold is 255 characters

VARCHAR (size) / VARCHAR2 (size):-
This data type is used to store variable length alphanumeric data. The maximum this data type can hold is 2000 characters

NUMBER (P,S):-
The NUMBER data type is used to store numbers. Numbers of virtually any magnitude maybe stored up to 38 digits. The precision (P), determines the maximum length of the data, whereas the scale (S), determines the number of places to the right of the decimal. If scale is omitted then the default is zero.If the values are stored with their original precision up to the maximum of 38 digits.

DATE:- This data type is used to represent date and time.

Post a Comment

Previous Post Next Post