Oracle查看表结构，可以导出到Excel

SELECT
	t.colUMN_NAME AS "名称",
	t.colUMN_NAME AS "代码",
	t.DATA_TYPE || '(' || t.DATA_LENGTH || ')' AS "数据类型",
	t1.COMMENTS AS "注释" 
FROM
	User_Tab_Cols t,
	User_Col_Comments t1 
WHERE
	t.table_name = t1.table_name 
	AND t.column_name = t1.column_name 
	AND t.table_name = 'T_PS_ROLE_MENU' 
ORDER BY
	t.column_id;