{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/150","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/150/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/150/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/150/events","html_url":"https://github.com/oracle/node-oracledb/issues/150","id":98097670,"number":150,"title":"how do I use 'Database Link' ?","user":{"login":"sukjin","id":6192728,"avatar_url":"https://avatars.githubusercontent.com/u/6192728?v=3","gravatar_id":"","url":"https://api.github.com/users/sukjin","html_url":"https://github.com/sukjin","followers_url":"https://api.github.com/users/sukjin/followers","following_url":"https://api.github.com/users/sukjin/following{/other_user}","gists_url":"https://api.github.com/users/sukjin/gists{/gist_id}","starred_url":"https://api.github.com/users/sukjin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sukjin/subscriptions","organizations_url":"https://api.github.com/users/sukjin/orgs","repos_url":"https://api.github.com/users/sukjin/repos","events_url":"https://api.github.com/users/sukjin/events{/privacy}","received_events_url":"https://api.github.com/users/sukjin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/oracle/node-oracledb/labels/question","name":"question","color":"cc317c"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-30T06:44:07Z","updated_at":"2015-08-18T22:41:01Z","closed_at":"2015-07-31T01:11:10Z","body":"\r\nI use Database Link with db tools.\r\n\r\nfor example.\r\n\r\nSELECT a.user_id, b.user_nm\r\n     FROM mydb a, mydb@LINK_MS b\r\n WHERE a.cd = b.cd\r\n\r\n\r\n\r\nand I use node-oracledb \r\n\r\nso I can query single db like   SELECT * FROM mydb\r\n\r\nbut I don't know how do I use 'Database Link' like @Link_MS ...\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/132377381","html_url":"https://github.com/oracle/node-oracledb/issues/150#issuecomment-132377381","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/150","id":132377381,"user":{"login":"cjbj","id":200778,"avatar_url":"https://avatars.githubusercontent.com/u/200778?v=3","gravatar_id":"","url":"https://api.github.com/users/cjbj","html_url":"https://github.com/cjbj","followers_url":"https://api.github.com/users/cjbj/followers","following_url":"https://api.github.com/users/cjbj/following{/other_user}","gists_url":"https://api.github.com/users/cjbj/gists{/gist_id}","starred_url":"https://api.github.com/users/cjbj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjbj/subscriptions","organizations_url":"https://api.github.com/users/cjbj/orgs","repos_url":"https://api.github.com/users/cjbj/repos","events_url":"https://api.github.com/users/cjbj/events{/privacy}","received_events_url":"https://api.github.com/users/cjbj/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T22:41:01Z","updated_at":"2015-08-18T22:41:01Z","body":"There isn't a specific example because there is nothing specific to node-oracledb.\r\nIf it's easiest for you to use a tnsnames.ora file, then go ahead and use one.\r\nOtherwise you can create the db link using the normal Easy Connect `hostname:port/servicename` syntax.\r\n\r\n(Yes, we may eventually add an example, time permitting: I recognize that if you need to ask, then we need to make it easier for you to find an answer)"}}