2

Oracle provides a "link" mechanism in order to access a different database instance than the one on which the query is running.

DIM_DATES@OTHERDB

Is there any ANSI SQL standard way to code this?

Paul White ♦
95.4k30 gold badges440 silver badges689 bronze badges
asked Sep 23, 2014 at 20:26
2
  • You're talking about Oracle DB links? Good question by the way. But i don't think that it has an ANSI similar command, cause it's based on Oracle TNS ... Commented Sep 23, 2014 at 20:27
  • Yes, referring to Oracle DB links. I found that it can refer to other database types if Oracle Heterogeneous Services is used. Is there any way to accomplish an equivalent using ANSI SQL standard? Commented Sep 24, 2014 at 15:34

1 Answer 1

2

SQL/MED (Management of External Data) is an extension to SQL standard defined by ISO/IEC 9075-9:2008. SQL/MED foreign-data wrappers can be used to refer to external RDBMS and non-RDBMS data sources.

While I don't think Oracle or MS SQL Server support SQL/MED, DB2 and PostgreSQL are supporting SQL/MED.

answered Nov 19, 2014 at 1:53

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.