Below query will returns you meta data of a given table associated column related meta data
SELECT data_type,
data_length,
data_precision,
data_scale,
nullable
FROM all_tab_columns
WHERE table_name = UPPER(:BindTableName)
AND column_name = UPPER(:BindColName)
No comments:
Post a Comment