Oracle 查找表的字段信息

SELECT
		column_name
	FROM
		user_tab_columns
	WHERE
		Table_Name = #{mapping_name,jdbcType=VARCHAR}

SELECT
	*
FROM
	user_col_comments
WHERE
	TABLE_NAME = 'AUDIT_QX'
posted @ 2019-10-15 10:44  ^sun^  阅读(663)  评论(0编辑  收藏  举报