TO_CHAR (character) converts NCHAR, NVARCHAR2, CLOB, or NCLOB data to the database character set. The value returned is always VARCHAR2. When you use this function to convert a character LOB into the ...

Another one of these choices... to go with a char or varchar for a field. Not really an issue with space since we are only looking at a couple of thousand records or so but just wondering what the ...