Performance question

From: Eric Levinson <nospam_at_nospam.com>
Date: Tue, 28 May 2002 23:23:15 GMT
Message-ID: <DjUI8.4416$3w2.19388@typhoon.sonic.net>

When a VARCHAR2 type column is defined, how does the LENGTH function get the length of the varchar contained in the column? Does it count up the number of bytes to some end of string marker, or is there an internally held and maintained attribute of varchar which maintains the size?

Reason why I am asking, there might be a performance hit to use LENGTH if it has to calculate it every time.

Any help would be appreciated

oracle at levinsong dot com Received on Tue May 28 2002 - 18:23:15 CDT