Most Database, such as Oracle, MySQL, MS SQL have various datatypes. These data types can be divided into diffrent categories as given below:
These are described below:
No | Datatype | Description |
---|---|---|
1 | Number(P,S) | Floating-point number P refers to precision S refers to scale |
2 | Number(P) | Fixed-point number with a scale zero and precision p |
3 | Number | Floating-point number with precision of 38 |
No | Datatype | Description |
---|---|---|
1 | CHAR(SIZE) | Fixed length character data of length size bytes. This should be used for fixed length data. Such as codes A100, B102..., 255 bytes Default and minimum size is 1 byte. |
2 | VARCHAR2(SIZE), VARCHAR2(SIZE) |
Variable length character string having maximum length size bytes. You must specify size max length is 2000 characters |
3 | LONG | Stores large amount of character strings of variable length max length is up to 2 GB |
No | Datatype | Description |
---|---|---|
1 | RAW | Stroes binary type data. maximum length is up to 255 bytes. |
2 | LONG RAW | Stroes large amount of binary type data. Max length is up to 2 gb. |
Ask Question