PL/SQL Datatpye


Prev Tutorial Next Tutorial

PL/SQL Datatpye

Same Datatpye are supported in PL/SQL which are supported in SQL.

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

Advertisements




Download Projects

Advertisements

Download WhatsApp Status Video

Buy This Ad Space Only $50 per Month, Ad Size 300X250