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
  • 94,921
  • 30
  • 437
  • 687
lit
  • 223
  • 3
  • 15

1 Answers1

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.