Re: column length for LPAD

Hi,

I donīt think I completely understand your question. Anyway I hope I can help you.

To determine the column length you can select it from the table USER_TAB_COLUMNS or ALL_TAB_COLUMNS.
To determine the best column of USER_TAB_COLUMNS to get the length for your variable just make a "DESC <table name>" ;-)

There are some options available to determine the length of a column: DATA_LENGTH:
Length of the column in bytes
DATA_PRECISION:
Length: decimal digits (NUMBER) or binary digits (FLOAT) DATA_SCALE:
Digits to right of decimal point in a number DEFAULT_LENGTH:
Length of default value for the column
AVG_COL_LEN:
The average length of the column in bytes CHAR_LENGTH:
The maximum length of the column in characters CHAR_USED:
C is maximum length given in characters, B if in bytes Hope this is what you wanted to know.
Thomas Received on Thu Jan 06 2005 - 09:53:24 CST