DataGrip：使用sql查询表信息用于粘贴到文档表格中

SQL: 

SELECT
	to_char(B.COLUMN_ID,'fm00') AS 字段序号,
	B.COLUMN_NAME AS 字段名,
	replace(A.COMMENTS,chr(10)) AS 字段说明,
	decode(B.DATA_PRECISION,null,cast(B.DATA_TYPE as varchar) || '(' || B.DATA_LENGTH || ')',B.DATA_TYPE || '('||B.DATA_PRECISION||','||B.DATA_SCALE||')') 字段数据类型,
	decode(B.COLUMN_ID,1,'主键',null) 主键,
	decode(B.NULLABLE,'N','否','Y','是') 允许为空
FROM
	ALL_COL_COMMENTS A,
	ALL_TAB_COLUMNS B,
	ALL_TAB_COMMENTS C
WHERE
	A.TABLE_NAME IN ( SELECT U.TABLE_NAME FROM USER_ALL_TABLES U )
	AND A.OWNER = B.OWNER
	AND A.TABLE_NAME = B.TABLE_NAME
	AND A.COLUMN_NAME = B.COLUMN_NAME
	AND C.TABLE_NAME = A.TABLE_NAME
	AND C.OWNER = A.OWNER
	AND A.OWNER = 'DGYH'
	AND A.TABLE_NAME = 'WT_SQDZZ'
ORDER BY
	A.TABLE_NAME,
	B.COLUMN_ID;

查询出的格式：

要粘贴的文档表格格式

 步骤：

1.先设置DataGrip

2.使用sql查询

3.全选sql查询出的内容

4.粘贴到对应表格行数的文档表格中

结果截图

通过表名拿取表的中文名（备注）