查询表某字段类型,如下:
SELECT data_type
FROM all_tab_cols
WHERE table_name = UPPER('SRIS_P_BaseInfo')
and column_name = 'REPORTDATE';
查询表某字段类型,如下:
SELECT data_type
FROM all_tab_cols
WHERE table_name = UPPER('SRIS_P_BaseInfo')
and column_name = 'REPORTDATE';