Oracle常用命令

1、创建索引

create sequence sequenceName minvalue 1 nomaxvalue start with 1;
select sequenceName.nextval from dual;

2、查询表字段

select * from user_tab_columns;

3、查询表索引

select * from user_indexes;

4、查询表列表

select * from user_tables;

5、查询表空间

select * from user_tablespaces;

6、查询所有序列

select * from allsequences;

7、字段增删改

alter table tablename add name varchr2(20);
alter table tablename modify name varchr2(50);
alter table tablename drop column name;

8、查询触发器

select * from all_triggers where table_name='';

9、查询用户

select * from all_Users;--查询所有用户
select * from user_users;--查询当前用户