There are several types of character data types for your use in SQL and PL/SQL. Unlike the NUMBER data type, there are some differences between SQL and PL/SQL character types.

I

won’t cover LOB (Large Objects) in this article. It could be argued

that a CLOB is nothing but a large string, but I will write a special

article to cover CLOBs, BLOB, and BFILEs.

Today I am going to

cover the three primary character types and talk a little about about

their differences and about some sub-types.

Read the rest of this post!