Determining char/varchar2 column length
- From: Adam Donahue <adonahue@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Jul 2004 12:30:07 -0700
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
