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

FREE Online Google Play APK Downloader

Buy APP Installs, Buy 100% Genuine Installs