Is there a way to specify a database link in an Oracle Select and Oracle Insert snap?
For example, I have a select statement with a DB link that I can run in an Oracle Execute snap (or in SQL Developer) like this:
select * from schema.table@db.mycompany.com;
However, there does not appear to be a way to specify the DB link in a Select snap. If I try to add @db.mycompany.com (example DB link name) in the Table name field in the snap I get an error to “please check SQL query”.