Social Icons

martes, 19 de noviembre de 2019

CONSULTAR LAS TABLAS QUE CONTIENEN EL NOMBRE DE UN ATRIBUTO

select table_name from all_tab_columns where column_name LIKE '%ATTR_NAME';

CHANGE DISPLAY UNIT EN OPENWELLS - CAMBIAR LAS UNIDADES DE DESPLIEGUE

A continuación tenemos un atributo de una ventana de OpenWells


update UMS_SYS_UNIT_MEASURES set MEASURE_LABEL=' ' WHERE MEASURE_ID=185

SELECT * FROM UMS_SYS_CLASS_ASSIGNMENTS
SELECT * FROM UMS_SYS_UNIT_CLASSES
SELECT * FROM UMS_SYS_UNIT_MEASURES WHERE MEASURE_ID=75
SELECT * FROM UMS_SYS_UNIT_SYSTEMS WHERE MEASURE_ID=75
SELECT * FROM UMS_SYS_UNIT_TYPES order by TYPE_LABEL
SELECT * FROM UMS_TU_MAPPING

Descargar cliente de Oracle 19c

  Oracle Database 19c Download for Microsoft Windows x64 (64-bit) https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

 
 
Blogger Templates