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 -> column_length in data dictionary views

column_length in data dictionary views

From: student <defaultuser_at_default.com>
Date: Thu, 18 Feb 1999 11:44:35 -0500
Message-ID: <36CC4373.15537380@default.com>


 Hello:
I'm a student and we're learning Oracle. In the data dictionary views, one of the fields that appear there is teh column_length (in several views such as the DBA_IND_COLUMNS. The definition that Oracle gives is teh following:
COLUMN_LENGTH : Indexed length of the column

Can anyone explain me what this mean??

For instance I ran the following query:

SELECT *
FROM USER_IND_COLUMNS
WHERE TABLE_NAME IN ('VARIETY', 'FLOWERS') AND Index_Name IN ('PK_VC','PK_FID');

and the result is

INDEX_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH
PK_VC		VARIETYCODE	1			22
PK_FID		FLOWERID	1			10

What the 22 and 10 mean??

Thanks for the help Received on Thu Feb 18 1999 - 10:44:35 CST

Original text of this message

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