Unit 3: .... Continue
The SQL supports a variety of data types as given below: Data types Description Size Number (P, S) It is used to store numeric data types. P stands for precision (total number of decimal digits) and S stands for scale (total number of digits after decimal point). Range of P is from 1 to 38. And S is from -87 to 127. Date It is used to store data and time values Range of date is from Jan, 47 B.C. to Dec 31 999 AD Char (Size) It is used to store fixed size character data. Range of char is 1 (By default) to 2000 bytes. Varchar(Size) It is used to store variable size character data. Range of varchar is 1 (By default) to 4000 bytes. Long It is used to store variable size character data. The range of Long is up to 2 GB Raw(size) It is used to store fixed binary data. Maximum size up to 2000 bytes. Long raw It is used to store va...