#1 SQL overview and list of data types in Oracle

#SQL (Oracle)

# 1 SQL overview and list of data types in Oracle

Database is stored and retrieved the data (date having different structure like
text,number,character,json,image,audio etc..,)

we create the structure to identify the data while stored information in
database using SQL statement.

#Data types

NUMBER -- allow number(both decimal,integer,possitive,negative data)

INTEGER --allow number(both decimal,integer,possitive,negative data)

VARCHAR-- allow character and strings data

VARCHAR2 -- allow combination of Number,strings and special character

DATE -- only date related data

TIMMESTAMP -- date and time related data

BLOB -- allow huge size data which more than 4000 data length

NCLOB -- similar to BLOB

BFILE -- allow image,video,audio

XMLTYPE -- allow xml script related data

JSON -- allow json data (set of data in single variable )

ANYDATA-- all kind of data sets