ABSTRACT

Data Types describe what type of data a column can hold. It is very important to understand the different data types for database developers and administrators. Three main data types are discussed in chapter 2: Characters, Numbers, and Date/Time. Tables are used to show the mappings between Oracle SQL, SQL Server T-SQL and MySQL data types. Oracle number examples and date time samples are provided. By the end of the chapter readers will understand the basic data types.