Re: Determining Varchar Maximum Length

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 19 Jan 2003 21:12:08 -0800
Message-ID: <92eeeff0.0301192112.469dfd1b@posting.google.com>

"Sam" <samlai_at_mail.utexas.edu> wrote in message news:<avl9j2$18o$1_at_geraldo.cc.utexas.edu>...
> Hi,
>
> I am writing a server in Java that connects to an Oracle database. I have a
> table called USERS. A column in USERS is called ID. ID has type
> VARCHAR(10). My problem is how do I write code that gets the size 10.
> Could it be done in SQL, PL/SQL, or some method from Oracle JDBC driver?
> Thanks a lot.
>
> Sam Lai

Look at java.sql.ResultSetMetaData.getColumnDisplaySize in JavaDocs.

Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery ("select a, b from my_table"); ResultSetMetaData rsmd = rset.getMetaData(); int size = rsmd.getColumnDisplaySize(1);

Regards
/Rauf Sarwar Received on Sun Jan 19 2003 - 23:12:08 CST