Oracle——基础篇

1. ## Oracle SQL

1.1. 用户管理

1.1.1. 创建

CREATE USER **DSJYW(**用户名) IDENTIFIED BY DSJYW(****密码);

CREATE USER **DSJYW** IDENTIFIED BY **DSJYW**;

1.1.2. 授权

GRANT connect,resource,dba TO **DSJYW**;

1.2. 创建自动增长器

1.2.1. 创建

CREATE sequence SEQ_SYS_PERMISSION START WITH 550 increment BY 1 MAXVALUE 99999999999 nominvalue nocycle nocache;

1.2.2. 删除

DROP SEQUENCE seq_student

1.3. 触发器

1.3.1. 创建触发器

CREATE 

  OR REPLACE TRIGGER TRIGGER_SYS_PERMISSION BEFORE INSERT ON SYS_PERMISSION FOR EACH ROW

DECLARE

BEGIN

SELECT

  SEQ_SYS_PERMISSION.nextval INTO : new.id 

FROM

  DUAL;

END;

1.3.2. 查看触发器

select * from all_triggers where table_name='SYS_PERMISSION';

1.3.3. 删除触发器

DROP TRIGGER **SYS_PERMISSION**

1.3.4. 新增字段（表中有数据的情况下）

Alter Table YW_TASK ADD COMPLEXITY Varchar2(10);