oracle 常用查询

--查询表对应的表空间

select table_name,tablespace_name from user_tables;

 

--查询表空间对应的数据文件(位置,大小...)
select a.name,b.name from v$tablespace a, v$datafile b where a.ts#=b.ts#;

修改用户密码

alter user wyp identified by wwyypp;
alter user wyp identified by wyp;

创建和删除表

create table test_test(name varchar2(20),id number);

drop table test_test; 

 
提交和回滚

commit
rollback

 

序列
create sequence seq_test_test;
create sequence seq_test_test start with 1000;
select seq_test_test.currval from dual;
select seq_test_test.nextval from dual;
drop sequence seq_test_test;

 

记录处理
insert into test_test(name) values('zjg');
update test_test set id = 1 where name = 'zjg';

 

修改表结构
alter table test_test add(sex varchar2(10));
alter table test_test modify(sex varchar2(20));
alter table test_test drop(sex);

 

授权和回收  
grant select on test_test to zjg;  
revoke select on test_test from zjg;
revoke all on test_test from zjg;