查看表结构 

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'

结果如下图：

 

posted @ 2015-11-11 16:25  韩梦芫  阅读(167)  评论(0)  编辑  收藏  举报