Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as SYSTEM@ORCL
SQL> grant create synonym to SCOTT;
Grant succeeded
SQL> conn scott/tiger;
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as SCOTT@ORCL
SQL> create synonym dept_info for DEPT;
Synonym created
SQL> select * from dept;
DEPTNO DNAME LOC
------ -------------- -------------
50 公关部 台湾
60 研发部 西安
70 培训部 西安
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
7 rows selected
SQL> select * from dept_info;
DEPTNO DNAME LOC
------ -------------- -------------
50 公关部 台湾
60 研发部 西安
70 培训部 西安
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
7 rows selected
SQL> update dept_info set LOC='香港' where deptno=60;
1 row updated
SQL> select * from dept_info;
DEPTNO DNAME LOC
------ -------------- -------------
50 公关部 台湾
60 研发部 香港
70 培训部 西安
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
7 rows selected
SQL> select * from dept;
DEPTNO DNAME LOC
------ -------------- -------------
50 公关部 台湾
60 研发部 香港
70 培训部 西安
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
7 rows selected
SQL>
