Oracle11g数据库基础教程张凤荔实验4

实验 4 管理索引和序列实验内容1.使用 SQL 语句创建索引语句如下：CREATE TABLE Users(UserID Number Primary key,UserName Varchar2(40) NOT NULL,UserType Number(1),UserPwd Varchar2(40));CREATE INDEX index_username ON Users(UserName)TABLESPACE Users;2.在创建表的同时创建索引语句如下：CREATE TABLE Employees(EmpId NUMBER PRIMARY KEY,EmpName VARCHAR2(50) UNIQUE,Sex CHAR(2),UserID NUMBER);3.使用 SQL 语句创建序列语句如下:CREATE SEQUENCE EMINVALUE 1NOMAXVALUE START WITH 1 INCREMENT BY 1 NOCYCLECACHE 20;4.在插入数据时使用序列语句如下:INSERT INTO Employees (EmpId, EmpName) VALUES (EMP_S.NEXTVAL, 'Employee1');INSERT INTO Employees (EmpId, EmpName) VALUES (EMP_S.NEXTVAL, 'Employee2');INSERT INTO Employees (EmpId, EmpName) VALUES (EMP_S.NEXTVAL, 'Employee3');COMMIT;SELECT * FROM Employees;