应用场景166:控制散列簇的空间使用
应用场景167:估算散列簇所需要的空间大小
应用场景168:修改和删除散列簇
应用场景169:使用DBA_CLUSTER_HASH_EXPRESSIONS视图查看散列函数
SELECT * FROM DBA_CLUSTER_HASH_EXPRESSIONS;
应用场景170:创建序列
CREATE SEQUENCE HRMAN.EMP_S
MINVALUE 1
NOMAXVALUE
START WITH 1
INCREMENT BY 1
NOCYCLE
CACHE 20;
应用场景171:修改序列
ALTER SEQUENCE HRMAN.EMP_S
MAXVALUE 10000;
应用场景172:删除序列
DROP SEQUENCE HRMAN.EMP_S;
应用场景173:序列的使用
CREATE SEQUENCE HRMAN.USER_S
MINVALUE 1
NOMAXVALUE
START WITH 1
INCREMENT BY 1
NOCYCLE
CACHE 20;
INSERT INTO HRMAN.USERS VALUES(HRMAN.USER_S.NEXTVAL, 'admin', 'pass');
应用场景174:创建同义词
CREATE PUBLIC SYNONYM HrEmployees FOR HRMAN.Employees;
应用场景175:使用系统视图DBA_SYNONYMS查看同义词的信息
COL OWNER FORMAT A10
COL SYNONYM_NAME FORMAT A10
COL TABLE_OWNER FORMAT A10
COL TABLE_NAME FORMAT A10
COL DB_LINK FORMAT A10
SELECT * FROM DBA_SYNONYMS
WHERE TABLE_NAME='EMPLOYEES';
应用场景176:在DML语句中使用同义词
COL EMP_NAME FORMAT A20
COL TITLE FORMAT A10
SELECT Emp_name, Title, Wage FROM HrEmployees;
应用场景177:删除同义词
DROP PUBLIC SYNONYM HrEmployees;