Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to determine the length of the biggest varchar2 column in a table?

Re: How to determine the length of the biggest varchar2 column in a table?

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/16
Message-ID: <32DF2DCE.4DFF@qrcsun.qrc.org>#1/1

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(name)) from tablename;

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841
Received on Thu Jan 16 1997 - 00:00:00 CST

Original text of this message

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