SQL Data Type

Advertisements

SQL Syntax Difference DBMS and RDBMS

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.


SQL Syntax Difference DBMS and RDBMS

Google Advertisment

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

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements