how to get the oracle datatype of a given column in java

[parijat67]

hi,

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".


thanks

Paul

[Shestakov]

1. Oracle has "numeric" datatype only on internal (database ) level, because Oracle has NUMBER datatype in db.

2. if u want to get information from db dictionary directly (not from ResultsetMetadata) u may use:

select DATA_TYPE,DATA_LENGTH ... from all_tab_columns
where
owner = 'SCHEMA' and
table_name = 'UR_TABLE' and
column_name = 'COL_NAME';