如何理解同义词synonym

本篇文章给大家分享的是有关如何理解同义词synonym，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。–目标库操作：192.168.56.11
[oracle@rhel ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 23 17:20:05 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> CONN hr/hr;
Connected.

SQL> create table syno as select * from user_objects;

Table created.

SQL>
SQL> select count(*) from syno;

COUNT(*)
———-
35

–源库操作：192.168.56.12
[oracle@wang admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 8 15:40:15 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn hr/hr;
Connected.
SQL> select * from tab;

TNAME TABTYPE CLUSTERID
—————————— ——- ———-
B_FILE_PACKAGE TABLE
B_PACKAGE_STATE_TRANS TABLE
COUNTRIES TABLE
DEPARTMENTS TABLE
EMPLOYEES TABLE
EMPLOYEES_BAK TABLE
EMP_DETAILS_VIEW VIEW
JOBS TABLE
JOB_HISTORY TABLE
LOCATIONS TABLE
REGIONS TABLE

11 rows selected.

SQL> create database link ora connect to hr identified by hr using ‘orcl’;

Database link created.

SQL> create synonym co for syno@ora;

Synonym created.

SQL> create synonym coe for hr.syno@ora;

Synonym created.

SQL> select count(*) from co;

COUNT(*)
———-
35

SQL> select count(*) from coe;

COUNT(*)
———-
35

SQL> desc co
Name Null? Type
—————————————– ——– —————————-
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)

SQL> 免费主机域名
SQL> desc coe
Name Null? Type
—————————————– ——– —————————-
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)

SQL> select object_name,object_id,object_type,status from co where rownum

查询验证完全相同，连个同义词co和coe！
以上就是如何理解同义词synonym，小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注云技术行业资讯频道。

相关推荐: Oracle11g DG MRP进程开启和关闭的方法是什么

这篇文章主要介绍“Oracle11g DG MRP进程开启和关闭的方法是什么”，在日常操作中，相信很多人在Oracle11g DG MRP进程开启和关闭的方法是什么问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Oracle11g…