oracle表结构

获取用户表结构

select dbms_metadata.get_ddl(u.object_type,u.object_name) from user_objects u where u.object_type in('TABLE','SEQUENCE','TRIGGER');