查看表结构

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