This article will require a little knowledge when using Oracle database. An Oracle database is is an object-relational database management system. An object-relational database, or object-relational database management system, is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, just as with proper relational systems, it supports extension of the data model with custom data-types and
An object-relational database can be said to provide a middle ground between relational databases and object-oriented databases.
This article will explain the best way to change field data type. When dealing with Oracle we must recognize that due to complexity of it over smaller databases like Microsoft access or MySQL. Unfortunately, since Oracle handles things differently changing a fields data type is a little more complicated.