Traditional Database Management System which only provide for primitive data types such as INTEGER and CHARACTER. The data types offered in commercial database systems, CHAR INTEGER NUMBER, VARCHAR, VARCHAR2(),are sufficient for most relational database applications but range wise varing from one data type to on their data type now beginning to realize that the ability to create userdefined data types can greatly simplify their database design, in existing system the data type int range from -2,147,483,648 to 2,147,483,647. This paper proposed new data type in sql named “ INTCAL “ range between from -9,223,372,036,854,775,999 to 9,223,372,036,854,775,999.
Keywords
RDBMS, sql, data bases, tables, columns, Data types and records
