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?
dblinksql-standard
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?
Best Answer
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.