We’ve got some XML data stored in the comments against tables on a system I’m working on – things like “Table Short Name (alias)”, “Legacy Key” and “SCD Type”, e.g. select table_name,commentsfrom dba_tab_commentswhere table_name=’BDM_T_CUSTOMER’; Table Name COMMENTS —————————— ———————BDM_T_CUSTOMER CUS We’re storing extra metadata in the comments for things we can’t easily store anywhere else. [...]
Archive of posts tagged xml