Oracle 常用command

1.  创建用户
create user userName identified by password;
eg: create user lxk identified by lxk;


2. 给用户授权
grant dba to lxk; --授权DBA权限给lxk
grant unlimited tablespace to lxk; --授权不限制的表空间
grant select any table to lxk;  --授权查询任何表
grant select an dictionary to lxk; --授权查询任何字典


3. 增加列
alter table tablename add (column datatype [default value][null/not null],….);


4. 修改列
alter table tablename modify (column datatype [default value][null/not null],….);


5. 删除列
alter table tablename drop (column);


6. 增加约束
alter table user
  add constraint FK_user_CLIENT foreign key (COMP_ID)
  references T_stal (COMP_ID);
 


7. 删除约束
alter table user drop constraint FK_user_CLIENT ;