desc table_name 可以查询表的结构 select field_name,... from ... 可以查询字段的值select * from all_tables where table_name like '%' select * from all_tab_columns where table_name='??'计算一个表占用的空间的大小 select owner,table_name, NUM_ROWS, BLOCKS*AAA/1024/1024 "Size M", EMPTY_BLOCKS, LAST_ANALYZED from dba_tables where table_name='XXX';
all_tables/dba_tables/user_tables 表信息
all_tab_columns/dba_tab_columns/user_tab_columns 表中字段信息
select field_name,... from ... 可以查询字段的值select * from all_tables where table_name like '%'
select * from all_tab_columns where table_name='??'计算一个表占用的空间的大小
select owner,table_name,
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
where table_name='XXX';