viernes, 22 de mayo de 2020
domingo, 17 de mayo de 2020
CONSULTAR COMO ESTA HECHO UN CONSTRAINT ORACLE
SELECT * FROM DBA_CONSTRAINTS WHERE CONSTRAINT_NAME='R_2819'
SELECT * FROM all_constraints WHERE CONSTRAINT_NAME='R_2819'
miércoles, 13 de mayo de 2020
MERGE
MERGE into GISTIC.ENCUESTAABRIL2018_1 t1
using (SELECT * FROM GISTIC.DOMINIO_CURSO_2020) t2
on (UPPER(t1.CURSO)=UPPER(t2.KEY_ID))
when matched then update set t1.ENABLED_FLAG='N',t1.ATTRIBUTE50='CC 4134',END_DATE_ACTIVE=SYSDATE
Suscribirse a:
Entradas (Atom)
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