Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Correspondence between oracle and xsd data types

3274437Sep 15 2016 — edited Sep 28 2016

Dear all,

Is there a way to get the RDF datatype for a given oracle data type before actually generating the triples?

For instance, the following query returns the Oracle datatypes of given owner/table/column:

SELECT data_type

FROM all_tab_columns

WHERE OWNER = '<owner>'

AND TABLE_NAME = '<table>'

AND COLUMN_NAME = '<column>'

But it is possible to also get the correspondent RDF datatype using only a SQL query like the above one? E.g. NUMBER gives me xsd:decimal

Thanks in advance,

Elisa.

This post has been answered by alwu-Oracle on Sep 16 2016
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 14 2016
Added on Sep 15 2016
1 comment
530 views