Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- v_c NUMBER(3);
- BEGIN
- SELECT 1 INTO v_c FROM user_tables WHERE table_name=UPPER('DC_AM_MOL');
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FAMILY';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='FAMILY';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_NAME';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='NAME';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_MIDDLE';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='MIDDLE';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_POSITION_VER1';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='POSITION';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER4';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER3';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER1';
- BEGIN
- SELECT 1 INTO v_c FROM cols WHERE table_name=UPPER('DC_AM_MOL') AND column_name='TFF_FIO_VER2';
- 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';
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- xception WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement