SELECT dbms_metadata.get_ddl('TABLE', tablename) FROM dual;
set long 5000000; set pagesize 9999; set head off;select dbms_metadata.get_ddl('TABLE','表名字,'COMM') from dual;
select * from dict_columns where table_name='your tablename';用这条SQL语句查出来的信息有: 表名,列名,列的注释信息.select * from user_tab_cols where table_name='your tablename';用这条SQL语句查出来的信息很多,包括:表名,列名,列的数据类型等一些表结构信息
set pagesize 9999;
set head off;select dbms_metadata.get_ddl('TABLE','表名字,'COMM') from dual;