Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to determine the length of the biggest varchar2 column in a table?
Maxwell MacLeod wrote:
> does anyone know how to do this? For example, if I had a field "name",
> which is varchar2(2000). One value is "Max" and another "Jeromino", I
> need to know the length of Jeromino.
SELECT Max(length(Column_Name))
FROM Your_Table;
-- Hui, Kwok Miu (Xu, Guo Miao) E-Mail: huikomix_at_dt.com.hk Assistant MIS Manager Tel : (00852)2589 3369 Cho Yang (Hong Kong) Co., Ltd. Fax : (00852)2559 3049Received on Thu Jan 16 1997 - 00:00:00 CST