Thursday, 8 August 2013

Why use varchar2 instead of char for package constants?

Why use varchar2 instead of char for package constants?

Just came across a package which defines a large number of package-global
constant strings as such:
DESTINATION_1 CONSTANT VARCHAR2(13) := '515 Pine Lane';
DESTINATION_2 CONSTANT VARCHAR2(18) := '670 Woodhaven Lane';
Is there any benefit to using varchar2 as the datatype for these over char?
Using Oracle 11g release 2.

No comments:

Post a Comment