ORACLE相关：表空间、序列、索引、分区、游标、存储过程、分区等创建.docVIP

实用文案 标准文档 --创建表空间 create tablespace text datafile F:/db/ordata/hibernate/text.dbf size 10m AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; --创建用户 create user text identified by text default tablespace text --为用户分配权限 grant connect,resource,dba to text; --用户登录表的结构 create table street( id NUMBER(5) primary key not null, p_id NUMBER(5), name VARCHAR2(18) not null, constraint s_fk_p_id foreign key (p_id) references district(id) ); --创建表 create table district( id NUMBER(5) primary key not null, name VARCHAR2(18) not null ); --创建序列 create sequence seq_street start with 1 increment by 1 nomaxvalue cache 10; create sequence seq_district start with 1 increment by 1 nomaxvalue cache 10; drop table street; drop table district; delete district; delete street; select * from street; select * from district; delete district where id != 6; --PL/SQL --插入数据 DECLARE v_id NUMBER(5) := 7; v_name VARCHAR2(18) := 汉阳区; BEGIN insert into district values(v_id,v_name); EXCEPTION When others then DBMS_OUTPUT.PUT_LINE(插入数据失败); END; --IF-THEN语句 DECLARE num1 number := 5; num2 number := 1; num3 number := 3; result varchar2(20); BEGIN IF num1 num2 THEN result := num1 is big; ELSIF num1 num2 THEN result := num3 is big; ELSE result := num2; END IF; DBMS_OUTPUT.PUT_LINE(result); END; --CASE 语句 DECLARE chap char := c; result varchar2(20); BEGIN CASE chap WHEN A THEN result := is A; WHEN B THEN result := is B; ELSE result := Ok!; END CASE; DBMS_OUTPUT.put_line(RESULT); END; --LOOP循环 DECLARE num4 number := 0; BEGIN LOOP num4 := num4+1; IF num4 10 THEN EXIT; END IF; DBMS_OUTPUT.PUT_LINE(num4); END LOOP; END; --WHILE LOOP循环 DECLARE num5