查看表结构

SELECT * FROM user_tab_columns WHERE TABLE_NAME='TZMLB'
UNION ALL
SELECT * FROM user_tab_columns WHERE TABLE_NAME='TZ_Z_ZYMXTZ'
UNION ALL
SELECT * FROM user_tab_columns WHERE TABLE_NAME='TZ_Z_TQMXTZ'
UNION ALL
SELECT * FROM user_tab_columns WHERE TABLE_NAME='TZ_Z_ZHMXTZ'
UNION ALL
SELECT * FROM user_tab_columns WHERE TABLE_NAME='TZ_Z_YDMXTZ'

结果如下图:

原文地址:https://www.cnblogs.com/siyunianhua/p/4956344.html