new第7节 表 索引 序列 视图.pptVIP

NEXTVAL 和 CURRVAL 伪列 只能在使用NEXTVAL后才能使用CURRVAL NEXTVAL 返回序列中下一个有效的值，任何用户都可以引用 CURRVAL 中存放序列的当前值 NEXTVAL 应在 CURRVAL 之前指定 ，二者应同时有效 7.4.2 使用序列 序列 DEPT_DEPTID_SEQ 的当前值 INSERT INTO departments(department_id, department_name, location_id) VALUES (dept_deptid_seq.NEXTVAL, Support, 2500); 1 row created. SELECT dept_deptid_seq.CURRVAL FROM dual; 7.4.3 删除序列 删除序列需要使用DROP SEQUENCE语句，其语法如下： DROP SEQUENCE sequence_name; 7.4.4 查询序列 查询数据字典视图 USER_SEQUENCES获取序列定义信息 如果指定NOCACHE 选项，则列LAST_NUMBER 显示序列中下一个有效的值 SELECT sequence_name, min_value, max_value, increment_by, last_number FROM user_sequences; 7.5 同义词 同义词，是表、索引和视图等模式对象的一个别名。与视图一样，同义词不占任何实际的存储空间，之中oracle的数据字典中保存期定义描述。在使用同义词时，oracle会将其翻译成为对应对象的名称。 使用同义词访问相同的对象（具有create synonym权限） 方便访问其它用户的对象 缩短对象名字的长度 CREATE [PUBLIC] SYNONYM synonym FOR object; Oracle中的同义词主要分为如下两类： 公有同义词 在数据库中的所有用户都可以使用。 私有同义词 有创建它的用户私人拥有。不过用户可以控制其他用户是否有权使用自己的同义词。 7.7 创建和删除同义词 为视图DEPT_SUM_VU 创建同义词 删除同义词 CREATE SYNONYM d_sum FOR dept_sum_vu; Synonym Created. DROP SYNONYM d_sum; Synonym dropped. * Lesson Aim Functions make the basic query block more powerful and are used to manipulate data values. This is the first of two lessons that explore functions. It focuses on single-row character, number, and date functions, as well as those functions that convert data from one type to another, for example, character data to numeric data. * Database Objects An Oracle database can contain multiple data structures. Each structure should be outlined in the database design so that it can be created during the build stage of database development. Table: Stores data View: Subset of data from one or more tables Sequence: Numeric value generator Index: Improves the performance of some queries Synonym: Gives alternative names to objects Oracle9i Table Structures Tables can be created at any time, even while users are using the database. You do not need to specify the size of any table. The size is ultimately defined by the amount of s