oracle 查询字段类型

SELECT Column_Name, DATA_TYPE from cols t1 LEFT JOIN user_objects ON t1.table_name = user_objects.OBJECT_NAME
where user_objects.OBJECT_TYPE='VIEW' AND t1.TABLE_NAME='JW_VJK_KCD_3'

 

posted @ 2019-10-21 23:47  老街巷口熟睡的猫  阅读(227)  评论(0编辑  收藏  举报