• Post Reply Bookmark Topic Watch Topic
  • New Topic

Retrieve the data types from the database

 
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: 20829
68
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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!