Oracle SQL 中“@”符号的含义是什么？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/296263/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the meaning of '@' symbol in Oracle SQL?
提问by tardate
回答by a2800276
It refers to a non-local table, the bit behind the @ is the db descriptor.
它指的是一个非本地表，@后面的位是db描述符。
select * from question_answer@abcd where id = '45'
Means select not from the local question_answertable, but from the table on the db desingated as abcd. The keyword to google for is dblink
意味着不是从本地question_answer表中选择，而是从指定为abcd. google 的关键字是dblink
回答by tardate
This is the syntax for accessing a table via a database link called "abcd" See the documentation for CREATE DATABASE LINK, or to see the defined db links:
这是通过名为“abcd”的数据库链接访问表的语法，请参阅CREATE DATABASE LINK的文档，或查看定义的数据库链接：
SELECT * FROM all_db_links;
