Re: Join Statement with math operation
Posted by:
Rick James
Date: August 22, 2010 08:51AM
Different sizes of VARCHAR have no impact on space consumed -- up to (255). VARCHAR is implemented as a length, plus the bytes needed to represent string. VARCHAR(20) will consume the same disk space as VARCHAR(10).
CHAR(...), on the other hand, is always padded out to the indicated size. CHAR(20) will consume twice the disk space as CHAR(10).
If you insert a string longer than 10 characters into CHAR(10) or VARCHAR(10), the value will be truncated.
Subject
Written By
Posted
Re: Join Statement with math operation
August 22, 2010 08:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.