grant create synonym to SCOTT

来源：互联网发布：dota2 mac怎么全屏编辑：程序博客网时间：2024/04/30 02:09
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>
0 0