| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Determining char/varchar2 column length
Adam, are you asking about the length of the actual data stored or the
declared length of the column?
The length function is available for the first item.
The data_length column of dba_tab_columns appears to give me the defined column length for varchar columns in both 8.1 and 9.2
Perhaps, I do not understand what you are really asking.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Adam Donahue
Sent: Wednesday, July 14, 2004 3:30 PM
To: oracle-l_at_freelists.org
Subject: Determining char/varchar2 column length
Folks,
Is there a single query or builtin PL/SQL routine that allows one to calculate the (character) length of a column that works for both 8i and 9i?
For 8i, character length = data_length
For 9i, character length = char_length (which /may/ equal data_length depending on the value of char_used)
Question, again, is whether there's a single query that can be run against both databases to accurately determine the length of a character-based column.
Thanks,
Adam
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |