mysql中别名的作用_数据库中别名的作用是什么您知道吗？

SQL> CONN system/manager@orcl;

Connected to Oracle Database 10g Enterprise Edition Release

10.2.0.3.0

Connected as system

SQL> CREATE USER XiaoMei IDENTIFIED BY XiaoMei;

①

User created

SQL> GRANT CONNECT TO XiaoMei;

Grant succeeded

SQL> GRANT RESOURCE TO XiaoMei;

Grant succeeded

SQL> GRANT CREATE SYNONYM TO XiaoMei;

Grant succeeded

SQL> CONN XiaoMei/XiaoMei@ORCL;

Connected to Oracle Database 10g Enterprise Edition Release

10.2.0.3.0

Connected as XiaoMei

SQL> CREATE SYNONYM MyEmp FOR SCOTT.EMP;

②

Synonym created

SQL> SELECT * FROM MYEMP;  ③

SELECT * FROM MYEMP

ORA-00942: 表或视图不存在

SQL> CONNECT SCOTT/tiger@ORCL

Connected to Oracle Database 10g Enterprise Edition Release

10.2.0.3.0

Connected as SCOTT

SQL> GRANT ALL ON EMP TO XiaoMei;  ④

Grant succeeded

SQL> CONNECT XiaoMei/XiaoMei@ORCL;

Connected to Oracle Database 10g Enterprise Edition Release

10.2.0.3.0

Connected as XiaoMei

SQL>  SELECT ENAME,JOB,SAL FROM MyEmp WHERE

SAL>2000; ⑤

ENAME

JOB

SAL

JONES

MANAGER

2975

BLAKE

MANAGER

2850

CLARK

MANAGER

2450

SCOTT

ANALYST

3000

KING

PRESIDENT

5000

FORD

ANALYST

3000

6 rows selected