select table_name,column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE,DATA_DEFAULT
from all_tab_columns where table_name='S_EDEAC'
//查看所有用户表
select table_name from user_tables
select * from user_objects where upper(object_type)='TABLE'
select * from all_objects where object_type='TABLE' and owner='用户'
select table_name from dba_tables where owner='USERNAME';
复制表结构
create table aa as select * from bb