select COLUMN_NAME ,DATA_TYPE FROM user_tab_columns t where t.TABLE_NAME = '表名'注意表名大写--该片段来自于http://www.codesnippet.cn/detail/0608201513366.html
来源: http://www.codesnippet.cn/detail/0608201513366.html