1.创建oracle表：

CREATE TABLE a

(

ORDER_ID INT NOT NULL,

ORDER DATE,

TOTAL INT,

ID VARCHAR(40)

)

PARTITION BY LIST (ORDER_DATE)

(

PARTITION P_20170101 VALUES (20170101) TABLESPACE tablename,

PARTITION P_20170102 VALUES (20170102) TABLESPACE tablename,

PARTITION P_20170103 VALUES (20170103) TABLESPACE tablename,

PARTITION P_20170104 VALUES (20170104) TABLESPACE tablename,

PARTITION P_20170105 VALUES (20170105) TABLESPACE tablename,

PARTITION P_20170106 VALUES (20170106) TABLESPACE tablename

);

2.查看当前用户的缺省表空间：

select username,default_tablespace from user_users;

3.查看当前用户的角色：

select * from user_role_privs;

4.查看用户下所有表：

select * from user_tables；

5.插入数据：

insert into tabname(字段名，字段名1)values(value1,value2);

6.删除数据：

delete from tabname where a=b

7.修改数据：

update tabname set a1=ba,a2=b2 where ...;

8.增加字段：

alter table tabname add 字段名；

9.删除表和它所有的约束条件：

drop table tabname cascade constraints;

10.修改所有权：

ALTER TABLE user OWNER TO user1;