File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Retrieve the data types from the database Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Retrieve the data types from the database" Watch "Retrieve the data types from the database" New topic
Author

Retrieve the data types from the database

nandhini sruthi
Greenhorn

Joined: Jan 11, 2008
Posts: 17
Hi,

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

Regards,
Sruthi.
Adinath Shirsath
Ranch Hand

Joined: Dec 04, 2007
Posts: 35
find the oracle system table which contains information about its data types and codes

hope it will help
nandhini sruthi
Greenhorn

Joined: Jan 11, 2008
Posts: 17
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
Sheriff

Joined: Oct 27, 2005
Posts: 19216

Check out java.sql.DatabaseMetaData#getTypeInfo()


SCJP 1.4 - SCJP 6 - SCWCD 5
How To Ask Questions How To Answer Questions
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1112

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.
 
I agree. Here's the link: jrebel
 
subject: Retrieve the data types from the database
 
Similar Threads
How to merge multiple ResultSet to 1
Types of data in a JTable cell
how to define data types in xml document
Retriew the values from the database using Struts2.
is Date a datatype