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
SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,NULLABLE
FROM USER_TAB_COLS where TABLE_NAME like 'SMS_EXTERNALSYSSMSREQUEST'
order by TABLE_NAME