Retrieve the data types from the database

[nandhini sruthi]

Hi,

Is there any way to Retrieve all the Data types for current RDBMS(oracle) using java matadata.

Regards,
Sruthi.

[Adinath Shirsath]

find the oracle system table which contains information about its data types and codes

hope it will help

[nandhini sruthi]

Thank you for your reply.
If you know the system table name in oracle 10g which can list all the Data types in oracle. Please let me know.This will very helpful for me.
Regards,
sruthi.

[Rob Spoor]

Check out java.sql.DatabaseMetaData#getTypeInfo()

[Avi Abrami]

Originally posted by nandhini sruthi:
Thank you for your reply.
If you know the system table name in oracle 10g which can list all the Data types in oracle. Please let me know.This will very helpful for me.
Regards,
sruthi.

The entire Oracle documentation set is available online via:

http://www.oracle.com/technology

I believe the information you seek is in the "Database Reference".

Good Luck,
Avi.