DATA TYPES :
DATA TYPE | DESCRIPTION | MAX SIZE |
VARCHAR2(SIZE) |
- Variable length character string having maximum length size bytes.
- You must specify size. We can use to store string values.
|
|
NUMBER(SIZE) |
- Number having precision P and scale S, which we can use to store number values.
|
- The precision P can range from 1 to 38.
- The scale can range from -84 to 127.
|
DATE |
- Valid Date range . We can use to store Date values
|
|
NULL : It is not a value and does not occupy any space.
TABLE: Table is the basic element in a database or object in database to store the data in the form of rows and columns.
0 comments:
Post a Comment