Hola,
Si se requieren actualizar multiples valores de un campo en PL/SQL, pueden utilizar el siguiente ejemplo:
UPDATE saberpro_limpio
SET estu_nivel_prgm_academico = 'UNIVERSITARIA'
WHERE estu_nivel_prgm_academico IS NULL
AND estu_prgm_academico LIKE ('%INGENIERIA%')
OR estu_prgm_academico LIKE ('%DERECHO%')
OR estu_prgm_academico LIKE ('%MEDICINA%')
OR estu_prgm_academico LIKE ('%ODONTOLOGIA%')
OR estu_prgm_academico LIKE ('%CONTADURIA%')
OR estu_prgm_academico LIKE ('%LICENCIATURA%')
OR estu_prgm_academico LIKE ('%PSICOLOGIA%')
OR estu_prgm_academico LIKE ('%ARQUITECTURA%')
OR estu_prgm_academico LIKE ('%ECOLOGIA%')
OR estu_prgm_academico LIKE ('%FISIOTERAPIA%')
OR estu_prgm_academico LIKE ('%ZOOTECNIA%')
OR estu_prgm_academico LIKE ('%ADMINISTRACIÓN%')
OR estu_prgm_academico LIKE ('%DISEÑO%')
OR estu_prgm_academico LIKE ('%SOCIAL%')
OR estu_prgm_academico LIKE ('%PUBLICIDAD%')
OR estu_prgm_academico LIKE ('%INTERNACIONAL%')
OR estu_prgm_academico LIKE ('%ARTES%')
OR estu_prgm_academico LIKE ('%PERIODISMO%')
OR estu_prgm_academico LIKE ('%GASTRONOMÍA%')
OR estu_prgm_academico LIKE ('%CIENCIA%')
OR estu_prgm_academico LIKE ('%TERAPIA%')
OR estu_prgm_academico LIKE ('%SALUD%');
0 comentarios :
Publicar un comentario