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.
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.