SQL Data Type


Prev Tutorial Next Tutorial

Data Type in SQL

In SQL Data Type defines a kind of value that a column can contain.

Data typeSyntax
1IntegerINTEGER
2SmallintSMALLINT
3NumericNUMERIC(P,S)
4RealREAL
5DecimalDECIMAL(P,S)
6FloatFLOAT(P)
7CharacterCHAR(X)
8Character varyingVARCHAR2(X)
9DateDate
10TimeTIME

Note: Data Type varies from database to database. For example, MySQL supports INT but Oracle supports NUMBER for integer values.


Prev Tutorial Next Tutorial

Yahoo Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com

Download Projects

Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Ads Advertisements