Advertisement
Vasiliok

Untitled

May 18th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 2.98 KB | None | 0 0
  1. DECLARE
  2.  v_c NUMBER(3);
  3.  BEGIN
  4.  SELECT 1 INTO v_c FROM user_tables WHERE table_name=UPPER('DC_AM_MOL');
  5.   BEGIN
  6.    SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FAMILY';
  7.     BEGIN
  8.      SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='FAMILY';
  9.       BEGIN
  10.        SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_NAME';
  11.         BEGIN
  12.          SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='NAME';
  13.           BEGIN
  14.            SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_MIDDLE';
  15.             BEGIN
  16.              SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='MIDDLE';
  17.               BEGIN
  18.                SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_POSITION_VER1';
  19.                 BEGIN
  20.                  SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='POSITION';
  21.                   BEGIN
  22.                    SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER4';
  23.                     BEGIN
  24.                      SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER3';
  25.                       BEGIN
  26.                        SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER1';
  27.                         BEGIN
  28.                          SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER2';
  29.                           EXECUTE IMMEDIATE 'update DC_AM_MOL set TFF_FAMILY = FAMILY, TFF_NAME = NAME, TFF_MIDDLE = MIDDLE, TFF_POSITION_VER2 = POSITION, TFF_FIO_VER4 = FAMILY || ' ' || NAME || ' ' || MIDDLE, TFF_FIO_VER3 = FAMILY || ' ' || NAME || ' ' || MIDDLE, TFF_FIO_VER1 = substr(NAME, 1,1) || '. ' || substr(MIDDLE, 1,1) || '. ' || FAMILY, TFF_FIO_VER2 = substr(NAME, 1,1) || '. ' || substr(MIDDLE, 1,1) || '. ' || FAMILY where TFF_FAMILY is null';
  30.                          EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  31.                         END;
  32.                        xception WHEN NO_DATA_FOUND THEN NULL;
  33.                       END;
  34.                      EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  35.                     END;
  36.                    EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  37.                   END;
  38.                  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  39.                 END;
  40.                EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  41.               END;
  42.              EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  43.             END;
  44.            EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  45.           END;
  46.          EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  47.         END;
  48.        EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  49.       END;
  50.      EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  51.     END;
  52.    EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  53.   END;
  54.  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  55. END;
  56. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement