Home » RDBMS Server » Server Administration » How oracle stores the varchar2
How oracle stores the varchar2 [message #63206] Fri, 17 September 2004 01:55 Go to next message
Milly
Messages: 72
Registered: March 2004
Member
HI!

I'd like to know how oracle stores the varchar2 datatype, just 'cause the length is variabile.

When I do a select, the system access rightly to the data or before test a bite-defined that identifies the right length of the data?

Report message to a moderator

Re: How oracle stores the varchar2 [message #63208 is a reply to message #63206] Fri, 17 September 2004 04:38 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

Oracle stores the length before the string value. But why do you care, as long as it works well and keeps on working well.

Best regards.

Frank

Report message to a moderator

Previous Topic: Performance with char and varchar2
Next Topic: Help! Database encounters ORA-0600 error frequently
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 04:03:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.