hi all,
This is too lengthy process i feel, instead iam getting details from user_tab_columns table. Any way thanks for your answer
Shashi
On Fri, 11 Feb 2005 Emmanuel Eze wrote :
>I wonder how u'd have a resultset without knowing the cloumn index. May be you did a "select * from tablename". If that is the case, get the cloumn count (getColumnCount()) and iterate through. While in the loop, get the the actual column name (getColumnName(index)) and then compare it to the cloumn name u want before calling getColumnDisplaySize on the index.
>
>Hope that helps.
>
>Emmanuel Eze
> ----- Original Message -----
> From: shashi kanth
> To: SERVLET-INTEREST@JAVA.SUN.COM
> Sent: Friday, February 11, 2005 11:20 AM
> Subject: doubt in oracle high priority
>
>
>
> hi All,
> Iam using oracle i need to get column width of a table.
> i can do it using ResultSetMetaData.getColumnDisplaySize(int i)
> but i don't know index of the column number but i know name of the column
> i mean to say is there method with name ResultSetMetaData.getColumnDisplaySize(String name)
> your help is appreciated
>
> thanx
> Shashi
>
>
>
> ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST".
> Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
>
>
>------------------------------------------------------------------------------
>
>
> Checked by Hu-fw-scar
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>Checked by Hu-fw-scar
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
