Why does Oracle force you define varchar2 limit?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Why does Oracle force you define varchar2 limit?

  1. #1
    Join Date
    Sep 2000
    Posts
    1
    Why does Oracle require you to define the maximum size of a varchar2, if a
    varchar2(10) and a varchar2(4000) both use the same amount of memory to
    store a given string? Is it merely for type checking, i.e., to give an
    automatic error if you try to store something longer than you expected? Or
    could there be some advantage to declaring a varchar2(10) rather than a
    varchar2(4000)?

    Question given to me by developer.

    Shawn
    Oracle DBA

  2. #2
    Join Date
    Jul 2000
    Posts
    37
    Hi,

    I don't think there is any advantage to specifying varchar2(10) as opposed to varchar2(50) storage-wise. Like you said, it's just to limit the amount of charachters that the field will accept.

    cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width