• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Retrieve the data types from the database

 
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 22862
132
Eclipse IDE Spring TypeScript Quarkus Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Check out java.sql.DatabaseMetaData#getTypeInfo()
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic