Tuesday, July 30, 2013

How to get Table Meta data


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