Oracle 常用查询

1. 查看Oracle版本

select * from v$version;

或者

select * from product_component_version;

2. 查看表结构

desc tableName

3. 查看表信息

select * from all_tables;
select * from all_tab_columns;
select * from all_tab_comments;
select * from user_constraints;