CONTROL       VARCHAR2(20 BYTE)               NOT NULL,
  CONTROL_VERS  NUMBER                          NOT NULL,
  FORM          NUMBER,
  FORM_VERS     NUMBER,
  CAPITOL       NUMBER,
  CAPITOL_VERS  NUMBER,
  ID_MD         NUMBER,
  FORMULA       VARCHAR2(1000 BYTE)             NOT NULL,
  SQL_TEXT      CLOB                            NOT NULL,
  PRIORITATEA   VARCHAR2(1 BYTE)                NOT NULL,
  DATA_REG      DATE                            NOT NULL,
  STATUT        VARCHAR2(1 BYTE)

(
SELECT
  'Rindu 1200 nu este completat' AS REZULTAT

FROM
  CIS.VW_DATA_ALL D


WHERE
  (D.PERIOADA IN(:PERIOADA)) AND
  (D.CUIIO=:CUIIO               OR :CUIIO = -1) AND
  (:CUIIO_VERS=:CUIIO_VERS     OR :CUIIO_VERS = -1) AND
  (D.FORM = :FORM               OR :FORM = -1) AND
  (D.FORM_VERS=:FORM_VERS       OR :FORM_VERS = -1) AND
  (D.CAPITOL=:CAPITOL           OR :CAPITOL = -1) AND
  (D.CAPITOL_VERS=:CAPITOL_VERS OR :CAPITOL_VERS = -1) AND
  (D.ID_MD=:ID_MD               OR :ID_MD = -1) AND
   D.FORM = 1 AND
   D.CAPITOL = 2
  )

VW_DATA_ALL

UPDATE CIS2.MD_CONTROL  A SET (A.SQL_TEXT) =  (
            SELECT B.SQL_TEXT
             FROM (
              SELECT
                  CONTROL,
                  CONTROL_VERS,
                  TRIM(REPLACE(dbms_lob.substr(SQL_TEXT,5000,1),'VW_DATA_ALL','VW_DATA_ALL_TEMP'))  SQL_TEXT
                  FROM (
                   SELECT *
                      FROM CIS2.MD_CONTROL
                      WHERE
                      1=1
                      AND
                      (dbms_lob.substr(SQL_TEXT,4000,1) NOT LIKE '%VW_DATA_ALL_TEMP%'
                      AND
                      dbms_lob.substr(SQL_TEXT,4000,1) NOT LIKE '%VW_DATA_ALL_COEF%')
                      )) B
                      WHERE
                      A.CONTROL = B.CONTROL AND A.CONTROL_VERS = B.CONTROL_VERS)
                      WHERE EXISTS
                      (
                      SELECT *
                      FROM (
                      SELECT
                      CONTROL,
                      CONTROL_VERS,
                      TRIM(REPLACE(dbms_lob.substr(SQL_TEXT,5000,1),'VW_DATA_ALL','VW_DATA_ALL_TEMP'))  SQL_TEX
                      FROM (
                    SELECT *
                     FROM CIS2.MD_CONTROL
                      WHERE
                      1=1 AND
                      (dbms_lob.substr(SQL_TEXT,4000,1) NOT LIKE '%VW_DATA_ALL_TEMP%'
                      AND
                      dbms_lob.substr(SQL_TEXT,4000,1) NOT LIKE '%VW_DATA_ALL_COEF%')))  B
                      WHERE
                      A.CONTROL = B.CONTROL
                      AND A.CONTROL_VERS = B.CONTROL_VERS
                      );

select *
  from (select '1234' a from dual union all
        select '12_4' a from dual)
 where a like '12_4'

select *
  from (select 'траляля VW_DATA_ALL парампампам' a from dual union all
        select 'траляля VW_DATA_ALL_TEMP парампампам' a from dual union all
        select 'упс VW0DATA0ALL что это' a from dual union all
        select 'бывает же VW1DATA1ALL1TEMP такое' a from dual union all
        select 'траляля VW_DATA_ALL_COEF парампампам' a from dual)
 where a like '%VW_DATA_ALL%' escape ''
   and a not like '%VW_DATA_ALL_TEMP%' escape ''
   and a not like '%VW_DATA_ALL_COEF%' escape ''

UPDATE CIS2.MD_CONTROL
   SET SQL_TEXT=trim(replace(SQL_TEXT,'VW_DATA_ALL','VW_DATA_ALL_TEMP'))
 WHERE regexp_like(SQL_TEXT,'VW_DATA_ALL')
   AND NOT regexp_like(SQL_TEXT,'VW_DATA_ALL_(TEMP|COEF)')