Thanks for all ur earlier responses.

We tried to use Java's (JDK 1.3) ResultsetMetadata class to get info on oracle datatype for a given column in a given table. We found that the integer , float , number datatypes are all mapped on to Java.Sql.Type.numeric. Is there any way to get the exact oracle datatype for the respective columns. For eg. if oracle datatype is float then the ResultsetMetadata also returns "float" instead of returning "numeric".