Re: NEWB question no. 1

From: Oliver Artelt <oli_at_MD.TRANSNET.de>
Date: Fri, 12 Jan 2001 17:13:30 +0100
Message-Id: <10739.126504@fatcity.com>

On Friday 12 January 2001 12:55, chigarden_at_netzero.net wrote:
> Good morning all !
>
> Okay...here goes with question #1
>
> In reading and playing with SQL*PLUS I see that there is CHAR ( text
> strings that are padded to the length you set) and VARCHAR2 (text strings
> that are not padded). My question is why would one ever use CHAR ? It
> seems it would require MUCH more space

... but can never lead to fragmented rowdata in the blocks. Play a little around with the concepts guide 'Data Blocks, Extents, and Segments'

oli

Oliver Artelt, System- und Datenbankadministration

---

  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19

   email: oli@cubeoffice.de # web: http://www.cubeoffice.de

---

Received on Fri Jan 12 2001 - 10:13:30 CST