oracle get DB column length defined

SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,NULLABLE
FROM USER_TAB_COLS where TABLE_NAME like 'SMS_EXTERNALSYSSMSREQUEST'
order by TABLE_NAME

posted on 2015-07-07 17:29  小柑  阅读(190)  评论(0编辑  收藏  举报