Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Retrieve the data types from the database  RSS feed

 
nandhini sruthi
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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

Regards,
Sruthi.
 
Adinath Shirsath
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
find the oracle system table which contains information about its data types and codes

hope it will help
 
nandhini sruthi
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 20941
81
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out java.sql.DatabaseMetaData#getTypeInfo()
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!