Need help with datatypes
i am facing a problem with datatypes. Could someone please help me solve this..
SQL> select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> desc ids_leave_types;
Name Null? Type
------------------------------- -------- ----
LEAVE_BUS_UNIT NOT NULL VARCHAR2(5)
LEAVE_LEAVE_TYPE NOT NULL VARCHAR2(5)
LEAVE_LEAVE_CLASS NOT NULL VARCHAR2(1)
LEAVE_DSCR_E NOT NULL VARCHAR2(30)
LEAVE_DSCR_A VARCHAR2(30)
LEAVE_ADJ_CODE NOT NULL VARCHAR2(5)
LEAVE_NATURE NOT NULL VARCHAR2(1)
LEAVE_CRE_BY NOT NULL VARCHAR2(30)