Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Does a varchar2 really use a variable amount of space?

Does a varchar2 really use a variable amount of space?

From: Hans Tallis <tallis_at_ers.com>
Date: Wed, 05 Aug 1998 11:37:32 +0100
Message-ID: <35C835EB.7B3188FE@ers.com>

If I declare a column varchar2(1000), and put "hello" into a row, is the database still using all 1000 bytes to store the row? Received on Wed Aug 05 1998 - 05:37:32 CDT

This message: [ Message body ]
Next message: Giuseppe De Santis: "time for parse"
Previous message: Wolfgang.Rothmayer_at_bmw.de: "Re: Creation of profile using PASSWORD_VERIFY_FUNCTION ??? (Was "Security for a group of users ???")"
Next in thread: oliver.willandsen_at_sg.cec.be: "Re: Does a varchar2 really use a variable amount of space?"
Reply: oliver.willandsen_at_sg.cec.be: "Re: Does a varchar2 really use a variable amount of space?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US