TABLAS DE OPENWELLS DE LAS TABLAS Y COLUMNAS

SELECT * FROM UMS_SYS_UNIT_CLASSES WHERE CLASS_ID=19

SELECT * FROM UMS_SYS_UNIT_MEASURES

SELECT * FROM UMS_SYS_UNIT_SYSTEMS WHERE SYSTEM_ID=6 AND CLASS_ID=19

SELECT * FROM UMS_SYS_UNIT_SYSTEMS_HEADER

SELECT * FROM MD_SYS_ATTR_DICTIONARY

select table_name from all_tab_columns where column_name='TABLE_NAME';
SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME='DM_EVENT'

SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME='DM_EVENT'

SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME='DM_EVENT'

SELECT * FROM MD_SITE_CONFIG_TRANSFER WHERE TABLE_NAME='DM_EVENT'

SELECT * FROM MD_SITE_STORAGE_UNITS WHERE TABLE_NAME='DM_EVENT'

SELECT * FROM MD_SYS_ATTR_DICTIONARY WHERE TABLE_NAME='DM_EVENT'

SELECT * FROM MD_SYS_FIELD_DEF WHERE TABLE_NAME='DM_EVENT'   //Definicion del tipo de atributo y legnth de cada tabla

SELECT * FROM MD_SYS_PICKLIST WHERE TABLE_NAME='DM_EVENT'    // CONSULTA QUE QUE TABLAS Y ATRIBUTOS TIENEN PICKLIST

SELECT * FROM MD_SYS_TABLE_DEF WHERE TABLE_NAME='CD_WELL'    //CONOCER EL PADRE DE LAS TABLAS

SELECT * FROM MD_UTIL_DESCENT WHERE TABLE_NAME='DM_EVENT'

SELECT * FROM MD_UTIL_FIELD_ATTR WHERE TABLE_NAME='DM_EVENT'

BUSCAR TODAS LAS TABLAS QUE TIENES UN CAMPO

select table_name from all_tab_columns where column_name='CLASS_ID';