CRITICAL SKILL 1.3

Learn the Basic Oracle Database 10g Data Types

Very early in one’s journey through the world of Oracle Database 10g, it becomes time to learn its common data types. Regardless of one’s past experiences in information technology, data types are nothing new. Let’s look at the most common type of data that can be stored in the Oracle Database 10g, keeping in mind that the list is much longer than the one we present here.

varchar2

By far the most common data type, varchar2 allows storage of just about any character that can be entered from a computer keyboard. In earlier software solutions, we commonly referred to this as alphanumeric data. The maximum length of varchar2 is 4000 bytes or characters. It is possible to store numeric ...

Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.