CREATE OR REPLACE procedure P_S13018_TEST as
--===================================================================================--

/*
Thursday, 12 February, 2015 11:51:42 AM - Sim Chun Seng method
*/

TYPE tbl IS TABLE OF CSM_DAILY_CKC%ROWTYPE;
src tbl;
row_update number(10):=0;
row_insert number(10):=0;
row_reject number(10):=0;
i number:=0;
j number:=0;
v_ErrorCode number;
v_Errortext varchar2(200);
start_time date := sysdate;
proc_name VARCHAR2(36) := 'P_S13018_TEST';
table_name VARCHAR2(36) := 'S13018_CSM_DAILY_CKC';
subject_area VARCHAR2(45) := 'CSM-CKC Daily Report';

begin

    select * BULK COLLECT into src
    from CSM_DAILY_CKC where system_date='13/12/2014';

      FOR i IN src.first .. src.last LOOP
        UPDATE S13018_CSM_DAILY_CKC SET
          CKC_ID = src(i).CKC_ID,
          SR_NUM = src(i).SR_NUM,
          TR_NUM = src(i).TR_NUM,
          CKC_STATUS = src(i).CKC_STATUS,
          CKC_CREATED_DATE = src(i).CKC_CREATED_DATE,
          SYSTEM_DATE = src(i).SYSTEM_DATE,
          AGING = src(i).AGING,
          CUSTOMER_NAME = src(i).CUSTOMER_NAME,
          SERVICE_NUM = src(i).SERVICE_NUM,
          LOGIN_ID = src(i).LOGIN_ID,
          SIEBEL_CUST_ID = src(i).SIEBEL_CUST_ID,
          PRIMARY_CONTACT = src(i).PRIMARY_CONTACT,
          MAIN_CONTACT_MOBILE = src(i).MAIN_CONTACT_MOBILE,
          MAIN_CONTACT_HOME = src(i).MAIN_CONTACT_HOME,
          MAIN_CONTACT_OFFICE = src(i).MAIN_CONTACT_OFFICE,
          MAIN_CONTACT_OFFICE_EXT = src(i).MAIN_CONTACT_OFFICE_EXT,
          BUILDING_ID = src(i).BUILDING_ID,
          CABINET_ID = src(i).CABINET_ID,
          DP_ID = src(i).DP_ID,
          DSLAM_ID = src(i).DSLAM_ID,
          DSLAM_CARD_SLOT = src(i).DSLAM_CARD_SLOT,
          CABLE_ID = src(i).CABLE_ID,
          DLC_CARD_SLOT = src(i).DLC_CARD_SLOT,
          VBBS_CODE = src(i).VBBS_CODE,
          ZONE_NAME = src(i).ZONE_NAME,
          STATE = src(i).STATE,
          CKC_DIAGNOSIS_CODE = src(i).CKC_DIAGNOSIS_CODE,
          CKC_OWNER_POSITION = src(i).CKC_OWNER_POSITION,
          CKC_CREATOR_GROUP = src(i).CKC_CREATOR_GROUP,
          CKC_CREATOR_POSITION = src(i).CKC_CREATOR_POSITION,
          MANUFACTURER_NUM = src(i).MANUFACTURER_NUM,
          LEVEL_IND = src(i).LEVEL_IND
        WHERE
          CKC_ID = src(i).CKC_ID and
          SIEBEL_CUST_ID = src(i).SIEBEL_CUST_ID and
          CUSTOMER_NAME = src(i).CUSTOMER_NAME and
          SERVICE_NUM = src(i).SERVICE_NUM
          ;

      row_update := row_update+1;

        IF SQL%ROWCOUNT = 0 THEN
          INSERT INTO S13018_CSM_DAILY_CKC (
          CKC_ID, SR_NUM, TR_NUM, CKC_STATUS, CKC_CREATED_DATE, SYSTEM_DATE, AGING, CUSTOMER_NAME, SERVICE_NUM, LOGIN_ID, SIEBEL_CUST_ID,
          PRIMARY_CONTACT, MAIN_CONTACT_MOBILE, MAIN_CONTACT_HOME, MAIN_CONTACT_OFFICE, MAIN_CONTACT_OFFICE_EXT, BUILDING_ID, CABINET_ID,
          DP_ID, DSLAM_ID, DSLAM_CARD_SLOT, CABLE_ID, DLC_CARD_SLOT, VBBS_CODE, ZONE_NAME, STATE, CKC_DIAGNOSIS_CODE, CKC_OWNER_POSITION,
          CKC_CREATOR_GROUP, CKC_CREATOR_POSITION, MANUFACTURER_NUM, LEVEL_IND
          )
          VALUES (
          src(i).CKC_ID, src(i).SR_NUM, src(i).TR_NUM, src(i).CKC_STATUS, src(i).CKC_CREATED_DATE, src(i).SYSTEM_DATE, src(i).AGING,
          src(i).CUSTOMER_NAME, src(i).SERVICE_NUM, src(i).LOGIN_ID, src(i).SIEBEL_CUST_ID, src(i).PRIMARY_CONTACT,
          src(i).MAIN_CONTACT_MOBILE, src(i).MAIN_CONTACT_HOME, src(i).MAIN_CONTACT_OFFICE, src(i).MAIN_CONTACT_OFFICE_EXT,
          src(i).BUILDING_ID, src(i).CABINET_ID, src(i).DP_ID, src(i).DSLAM_ID, src(i).DSLAM_CARD_SLOT, src(i).CABLE_ID, src(i).DLC_CARD_SLOT,
          src(i).VBBS_CODE, src(i).ZONE_NAME, src(i).STATE, src(i).CKC_DIAGNOSIS_CODE, src(i).CKC_OWNER_POSITION, src(i).CKC_CREATOR_GROUP,
          src(i).CKC_CREATOR_POSITION, src(i).MANUFACTURER_NUM, src(i).LEVEL_IND
          );

        row_insert := row_insert +1;

        END IF;

      END LOOP;

--      LOG ERRORS INTO ('daily_load') REJECT LIMIT 25;
      commit;

        dbms_output.put_line(chr(0));
        dbms_output.put_line(chr(10));
        dbms_output.put_line('UPDATE for '||table_name);
        dbms_output.put_line('-------------------------------------------------');
        dbms_output.put_line(chr(0));
        DBMS_OUTPUT.PUT_LINE (row_update ||' rows have been updated!');
        DBMS_OUTPUT.PUT_LINE (row_insert ||' rows have been inserted!');
        DBMS_OUTPUT.PUT_LINE (row_reject ||' rows have been rejected!');
        DBMS_OUTPUT.PUT_LINE('error_code:'||v_ErrorCode);
        DBMS_OUTPUT.PUT_LINE('error_msg:'||v_ErrorText);
        dbms_output.put_line(chr(0));

     insert into PROCEDURE_TRACKING_LOG
     (procedure_name, table_name, rows_inserted, rows_updated, rows_deleted, rows_inserted_of_deletion, rows_inserted_after_deletion,
      rows_rejected, start_time, end_time, elapse_time, remarks, subject_area)
     values
     (proc_name,
   table_name,row_insert,row_update,NULL,NULL,NULL,row_reject,start_time,sysdate,(sysdate-start_time)* 86400,
      v_ErrorText,subject_area);

commit;

END;
/

dwh job should be performed in bulks rather than row by row.
example below is many times simpler and standard... 

BEGIN
 INSERT INTO s53449.test1
    SELECT account_num
        FROM tel_profile
        WHERE rownum < 100
    LOG ERRORS INTO s53449.err ('daily_load') REJECT LIMIT 25;
    commit;
      DBMS_OUTPUT.PUT_LINE('record inserted: ' || TO_CHAR(SQL%ROWCOUNT));
END;
/

CREATE OR REPLACE procedure P_S13018_TEST as
--===================================================================================--

cursor A is
select* from CSM_DAILY_CKC where system_date='13/12/2014';

arec A%rowtype;

row_update number(10):=0;
row_insert number(10):=0;
row_reject number(10):=0;
i number:=0;
j number:=0;
v_ErrorCode number;
v_Errortext varchar2(200);
start_time date := sysdate;
proc_name VARCHAR2(36) := 'P_S13018_TEST';
table_name VARCHAR2(36) := 'S13018_CSM_DAILY_CKC';
subject_area VARCHAR2(45) := 'CSM-CKC Daily Report';

begin

     OPEN  A;

     loop
     FETCH A INTO arec;
     exit when A%notfound;

     BEGIN


        UPDATE S13018_CSM_DAILY_CKC SET
          CKC_ID = arec.CKC_ID,
          SR_NUM = arec.SR_NUM,
          TR_NUM = arec.TR_NUM,
          CKC_STATUS = arec.CKC_STATUS,
          CKC_CREATED_DATE = arec.CKC_CREATED_DATE,
          SYSTEM_DATE = arec.SYSTEM_DATE,
          AGING = arec.AGING,
          CUSTOMER_NAME = arec.CUSTOMER_NAME,
          SERVICE_NUM = arec.SERVICE_NUM,
          LOGIN_ID = arec.LOGIN_ID,
          SIEBEL_CUST_ID = arec.SIEBEL_CUST_ID,
          PRIMARY_CONTACT = arec.PRIMARY_CONTACT,
          MAIN_CONTACT_MOBILE = arec.MAIN_CONTACT_MOBILE,
          MAIN_CONTACT_HOME = arec.MAIN_CONTACT_HOME,
          MAIN_CONTACT_OFFICE = arec.MAIN_CONTACT_OFFICE,
          MAIN_CONTACT_OFFICE_EXT = arec.MAIN_CONTACT_OFFICE_EXT,
          BUILDING_ID = arec.BUILDING_ID,
          CABINET_ID = arec.CABINET_ID,
          DP_ID = arec.DP_ID,
          DSLAM_ID = arec.DSLAM_ID,
          DSLAM_CARD_SLOT = arec.DSLAM_CARD_SLOT,
          CABLE_ID = arec.CABLE_ID,
          DLC_CARD_SLOT = arec.DLC_CARD_SLOT,
          VBBS_CODE = arec.VBBS_CODE,
          ZONE_NAME = arec.ZONE_NAME,
          STATE = arec.STATE,
          CKC_DIAGNOSIS_CODE = arec.CKC_DIAGNOSIS_CODE,
          CKC_OWNER_POSITION = arec.CKC_OWNER_POSITION,
          CKC_CREATOR_GROUP = arec.CKC_CREATOR_GROUP,
          CKC_CREATOR_POSITION = arec.CKC_CREATOR_POSITION,
          MANUFACTURER_NUM = arec.MANUFACTURER_NUM,
          LEVEL_IND = arec.LEVEL_IND
        WHERE
          CKC_ID = arec.CKC_ID and
          SIEBEL_CUST_ID = arec.SIEBEL_CUST_ID and
          CUSTOMER_NAME = arec.CUSTOMER_NAME and
          SERVICE_NUM = arec.SERVICE_NUM
          ;

     IF SQL%FOUND then
     row_update := row_update+1;
    else
    
       INSERT INTO CSM_DAILY_CKC
       (CKC_ID, SR_NUM, TR_NUM, CKC_STATUS, CKC_CREATED_DATE, SYSTEM_DATE, AGING, CUSTOMER_NAME, SERVICE_NUM, LOGIN_ID, SIEBEL_CUST_ID,
        PRIMARY_CONTACT, MAIN_CONTACT_MOBILE, MAIN_CONTACT_HOME, MAIN_CONTACT_OFFICE, MAIN_CONTACT_OFFICE_EXT, BUILDING_ID, CABINET_ID,
        DP_ID, DSLAM_ID, DSLAM_CARD_SLOT, CABLE_ID, DLC_CARD_SLOT, VBBS_CODE, ZONE_NAME, STATE)
       VALUES
       (arec.CKC_ID, arec.SR_NUM, arec.TR_NUM, arec.CKC_STATUS, arec.CKC_CREATED_DATE, arec.SYSTEM_DATE, arec.AGING, arec.CUSTOMER_NAME,
        arec.SERVICE_NUM, arec.LOGIN_ID, arec.SIEBEL_CUST_ID, arec.PRIMARY_CONTACT, arec.MAIN_CONTACT_MOBILE, arec.MAIN_CONTACT_HOME,
        arec.MAIN_CONTACT_OFFICE, arec.MAIN_CONTACT_OFFICE_EXT, arec.BUILDING_ID, arec.CABINET_ID, arec.DP_ID, arec.DSLAM_ID,
        arec.DSLAM_CARD_SLOT, arec.CABLE_ID, arec.DLC_CARD_SLOT, arec.VBBS_CODE, arec.ZONE_NAME, arec.STATE)
        ;

     row_insert := row_insert +1;

     i := i + 1;

     if i > 500 then
     commit;
     i := 0;
     end if;

END IF;

     exception when others then
     row_reject:=row_reject+1;
     v_ErrorCode :=SQLCODE;
     v_ErrorText :=SUBSTR(SQLERRM,1,200);


     end;

     i := i + 1;

     if i > 500 then
     commit;
     i := 0;
     end if;

     END LOOP;


     close A;

    dbms_output.put_line(chr(0));
     dbms_output.put_line(chr(10));
     dbms_output.put_line('UPDATE for '||table_name);
     dbms_output.put_line('-------------------------------------------------');
    dbms_output.put_line(chr(0));
    DBMS_OUTPUT.PUT_LINE (row_update ||' rows have been updated!');
     DBMS_OUTPUT.PUT_LINE (row_insert ||' rows have been inserted!');
     DBMS_OUTPUT.PUT_LINE (row_reject ||' rows have been rejected!');
     DBMS_OUTPUT.PUT_LINE('error_code:'||v_ErrorCode);
     DBMS_OUTPUT.PUT_LINE('error_msg:'||v_ErrorText);
     dbms_output.put_line(chr(0));

     insert into PROCEDURE_TRACKING_LOG
     (procedure_name, table_name, rows_inserted, rows_updated, rows_deleted, rows_inserted_of_deletion, rows_inserted_after_deletion,
      rows_rejected, start_time, end_time, elapse_time, remarks, subject_area)
     values
     (proc_name,
   table_name,row_insert,row_update,NULL,NULL,NULL,row_reject,start_time,sysdate,(sysdate-start_time)* 86400,
      v_ErrorText,subject_area);

commit;

END;
/

BEGIN
 INSERT INTO s53449.test1
    SELECT account_num
        FROM tel_profile
        WHERE rownum < 100
    LOG ERRORS INTO s53449.err ('daily_load') REJECT LIMIT 25;
    commit;
      DBMS_OUTPUT.PUT_LINE('record inserted: ' || TO_CHAR(SQL%ROWCOUNT));
END;
/

CREATE OR REPLACE procedure P_S13018_TEST (param varchar2) as
--===================================================================================--

/*
Thursday, 12 February, 2015 11:51:42 AM - Sim Chun Seng method
*/

row_update number(10):=0;
row_insert number(10):=0;
row_reject number(10):=0;
i number:=0;
j number:=0;
v_ErrorCode number;
v_Errortext varchar2(200);
start_time date := sysdate;
proc_name VARCHAR2(36) := 'P_S13018_TEST';
table_name VARCHAR2(36) := 'S13018_CSM_DAILY_CKC';
subject_area VARCHAR2(45) := 'CSM-CKC Daily Report';
custom_text VARCHAR2(36) := param;

begin

    etl.reset_counters;
    MERGE INTO S13018_CSM_DAILY_CKC tgt
    USING (select * from S13018_CSM_DAILY_bkp where ckc_status=param) SRC
    ON  (tgt.CKC_ID = src.CKC_ID and
        tgt.SIEBEL_CUST_ID = src.SIEBEL_CUST_ID and
        tgt.CKC_CREATED_DATE = src.CKC_CREATED_DATE and
        tgt.SERVICE_NUM = src.SERVICE_NUM)
    /* update the data */
    WHEN MATCHED THEN
    UPDATE
    SET
          SR_NUM = CASE ETL.MERGE_COUNTER(ETL.C_UPDATING) when 0 then  SRC.sr_num END,
          TR_NUM = src.TR_NUM,
          CKC_STATUS = src.CKC_STATUS,
          SYSTEM_DATE = src.SYSTEM_DATE,
          AGING = src.AGING,
          CUSTOMER_NAME = src.CUSTOMER_NAME,
          LOGIN_ID = src.LOGIN_ID,
          PRIMARY_CONTACT = src.PRIMARY_CONTACT,
          MAIN_CONTACT_MOBILE = src.MAIN_CONTACT_MOBILE,
          MAIN_CONTACT_HOME = src.MAIN_CONTACT_HOME,
          MAIN_CONTACT_OFFICE = src.MAIN_CONTACT_OFFICE,
          MAIN_CONTACT_OFFICE_EXT = src.MAIN_CONTACT_OFFICE_EXT,
          BUILDING_ID = src.BUILDING_ID,
          CABINET_ID = src.CABINET_ID,
          DP_ID = src.DP_ID,
          DSLAM_ID = src.DSLAM_ID,
          DSLAM_CARD_SLOT = src.DSLAM_CARD_SLOT,
          CABLE_ID = src.CABLE_ID,
          DLC_CARD_SLOT = src.DLC_CARD_SLOT,
          VBBS_CODE = src.VBBS_CODE,
          ZONE_NAME = src.ZONE_NAME,
          STATE = src.STATE,
          CKC_DIAGNOSIS_CODE = src.CKC_DIAGNOSIS_CODE,
          CKC_OWNER_POSITION = src.CKC_OWNER_POSITION,
          CKC_CREATOR_GROUP = src.CKC_CREATOR_GROUP,
          CKC_CREATOR_POSITION = src.CKC_CREATOR_POSITION,
          MANUFACTURER_NUM = src.MANUFACTURER_NUM,
          LEVEL_IND = src.LEVEL_IND,
          timestamp = sysdate
    WHEN NOT MATCHED THEN
          INSERT (
          CKC_ID, SR_NUM, TR_NUM, CKC_STATUS, CKC_CREATED_DATE, SYSTEM_DATE, AGING, CUSTOMER_NAME, SERVICE_NUM, LOGIN_ID, SIEBEL_CUST_ID,
          PRIMARY_CONTACT, MAIN_CONTACT_MOBILE, MAIN_CONTACT_HOME, MAIN_CONTACT_OFFICE, MAIN_CONTACT_OFFICE_EXT, BUILDING_ID, CABINET_ID,
          DP_ID, DSLAM_ID, DSLAM_CARD_SLOT, CABLE_ID, DLC_CARD_SLOT, VBBS_CODE, ZONE_NAME, STATE, CKC_DIAGNOSIS_CODE, CKC_OWNER_POSITION,
          CKC_CREATOR_GROUP, CKC_CREATOR_POSITION, MANUFACTURER_NUM, LEVEL_IND
          )
          VALUES (
          CASE ETL.MERGE_COUNTER(ETL.c_inserting) when 0 then SRC.ckc_id END, src.SR_NUM, src.TR_NUM, src.CKC_STATUS, src.CKC_CREATED_DATE, src.SYSTEM_DATE, src.AGING,
          src.CUSTOMER_NAME, src.SERVICE_NUM, src.LOGIN_ID, src.SIEBEL_CUST_ID, src.PRIMARY_CONTACT,
          src.MAIN_CONTACT_MOBILE, src.MAIN_CONTACT_HOME, src.MAIN_CONTACT_OFFICE, src.MAIN_CONTACT_OFFICE_EXT,
          src.BUILDING_ID, src.CABINET_ID, src.DP_ID, src.DSLAM_ID, src.DSLAM_CARD_SLOT, src.CABLE_ID, src.DLC_CARD_SLOT,
          src.VBBS_CODE, src.ZONE_NAME, src.STATE, src.CKC_DIAGNOSIS_CODE, src.CKC_OWNER_POSITION, src.CKC_CREATOR_GROUP,
          src.CKC_CREATOR_POSITION, src.MANUFACTURER_NUM, src.LEVEL_IND
          );

    row_insert:=etl.get_merge_insert_count;
    row_update:=etl.get_merge_update_count(sql%rowcount);

    commit;

	    insert into PROCEDURE_TRACKING_LOG
	    (procedure_name, table_name, rows_inserted, rows_updated, rows_deleted, rows_inserted_of_deletion, rows_inserted_after_deletion,
	    rows_rejected, start_time, end_time, elapse_time, remarks, subject_area)
	    values
	    (proc_name||replace(decode(custom_text,null,null,' ('||custom_text||')'),' ()'),
      table_name,row_insert,row_update,NULL,NULL,NULL,row_reject,start_time,sysdate,(sysdate-start_time)* 86400,
	    v_ErrorText,subject_area);

      commit;

      dbms_output.put_line(chr(0));
      dbms_output.put_line(chr(10));
      dbms_output.put_line('UPDATE for '||table_name);
      dbms_output.put_line('-------------------------------------------------');
      dbms_output.put_line(chr(0));
      DBMS_OUTPUT.PUT_LINE (row_update ||' rows have been updated!');
      DBMS_OUTPUT.PUT_LINE (row_insert ||' rows have been inserted!');
      DBMS_OUTPUT.PUT_LINE (row_reject ||' rows have been rejected!');
      DBMS_OUTPUT.PUT_LINE('error_code:'||v_ErrorCode);
      DBMS_OUTPUT.PUT_LINE('error_msg:'||v_ErrorText);
      dbms_output.put_line(chr(0));

     exception when others then
     row_reject:=sql%bulk_exceptions.count;
     v_ErrorCode :=SQLCODE;
     v_ErrorText :=SUBSTR(SQLERRM,1,200);
--      LOG ERRORS INTO ('daily_load') REJECT LIMIT 25;
      commit;

END;
/

etl.get_merge_insert_count
etl.get_merge_update_count

CREATE OR REPLACE PACKAGE CRISPBATCH.ETL AS

   c_inserting CONSTANT PLS_INTEGER := 0;
   c_updating  CONSTANT PLS_INTEGER := 1;

   FUNCTION merge_counter (
            action_in IN PLS_INTEGER DEFAULT c_inserting
            ) RETURN PLS_INTEGER;

   FUNCTION get_merge_update_count RETURN PLS_INTEGER;

   FUNCTION get_merge_update_count (
            merge_count_in IN PLS_INTEGER
            ) RETURN PLS_INTEGER;

   FUNCTION get_merge_insert_count RETURN PLS_INTEGER;

   FUNCTION get_merge_insert_count (
            merge_count_in in PLS_INTEGER
            ) RETURN PLS_INTEGER;

   PROCEDURE reset_counters;

END etl;
/

CREATE OR REPLACE PACKAGE BODY CRISPBATCH.ETL AS

   g_update_counter PLS_INTEGER NOT NULL := 0;
   g_insert_counter PLS_INTEGER NOT NULL := 0;

/*-------------- START OF FUNCTION merge_counter --------------------*/
FUNCTION merge_counter (
         action_in IN PLS_INTEGER DEFAULT c_inserting
         ) RETURN PLS_INTEGER IS
BEGIN
   CASE action_in
      WHEN c_updating
         THEN g_update_counter := g_update_counter + 1;
      WHEN c_inserting
         THEN g_insert_counter := g_insert_counter + 1;
      ELSE
         RAISE PROGRAM_ERROR;
   END CASE;
   RETURN 0;
END merge_counter;

/*----------- START OF FUNCTION get_merge_update_count V1 ---------------*/
FUNCTION get_merge_update_count
   RETURN PLS_INTEGER is
BEGIN
   RETURN g_update_counter;
END get_merge_update_count;

/*----------- START OF FUNCTION get_merge_update_count V2 ---------------*/
FUNCTION get_merge_update_count (
         merge_count_in IN PLS_INTEGER
         ) RETURN PLS_INTEGER IS
BEGIN
   RETURN NVL( merge_count_in - g_insert_counter, 0 );
END get_merge_update_count;

/*----------- START OF FUNCTION get_merge_insert_count V1 ---------------*/
FUNCTION get_merge_insert_count
   RETURN PLS_INTEGER IS
BEGIN
   RETURN g_insert_counter;
END get_merge_insert_count;

/*----------- START OF FUNCTION get_merge_insert_count V2 ---------------*/
FUNCTION get_merge_insert_count (
         merge_count_in IN PLS_INTEGER
         ) RETURN PLS_INTEGER IS
BEGIN
   RETURN NVL( merge_count_in - g_update_counter, 0 );
END get_merge_insert_count;

/*-------------- START OF FUNCTION reset_counters --------------------*/
PROCEDURE reset_counters IS
BEGIN
   g_update_counter := 0;
   g_insert_counter := 0;
END reset_counters;

END etl;
/

from CSM_DAILY_CKC where system_date='13/12/2014';

from CSM_DAILY_CKC where system_date=to_date('13/12/2014');

select LENGTHB('é') from dual@crisp_cams; - 1

select LENGTHB('é') from dual; - 3

TRANSLATE(col,
          'ƒŠŒŽšœžŸÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïøðñòóôõöùúûüýÿÞþ',
          'fSEZsezYAAAAAAECEEEEIIIIDNOOOOOOUUUUYBaaaaaaeceeeeiiiioonooooouuuuyy')

SQL> select ascii('é') from dual;
ASCII('é')
----------
       130

1 row selected.

SQL> begin
  2    for i in 128..255 loop
  3      dbms_output.put(chr(i));
  4    end loop;
  5    dbms_output.new_line;
  6  end;
  7  /
ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø׃áíóúñѪº¿®... (output truncated)

PL/SQL procedure successfully completed.

SELECT '@#$*%ÄÊÍÓØABCDE' original_text, CONVERT('@#$*%ÄÊÍÓØABCDE', 'WE8MSWIN1252', 'AL32UTF8') modified_text,
lengthb('@#$*%ÄÊÍÓØABCDE') original_length,
lengthb(CONVERT('@#$*%ÄÊÍÓØABCDE', 'WE8MSWIN1252', 'AL32UTF8')) modified_length
from dual;

SQL> with
  2    data as (
  3      select 'ambiguïté séquoia après déjà français' original_text
  4      from dual
  5    )
  6  SELECT original_text,
  7         CONVERT(original_text, 'WE8MSWIN1252', 'AL32UTF8') modified_text
  8  from data
  9  /
ORIGINAL_TEXT                            MODIFIED_TEXT
---------------------------------------- ----------------------------------------
ambiguïté séquoia après déjà français    ambigu¿t¿ s¿quoia apr¿s d¿j¿ fran¿ais

SQL> with
  2    data as (
  3      select 'ambiguïté séquoia après déjà français' original_text
  4      from dual
  5    )
  6  SELECT original_text,
  7         translate(original_text,
  8                   'ƒŠŒŽšœžŸÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïøðñòóôõöùúûüýÿÞþ',
  9                   'fSEZsezYAAAAAAECEEEEIIIIDNOOOOOOUUUUYBaaaaaaeceeeeiiiioonooooouuuuyy')
 10           modified_text
 11  from data
 12  /
ORIGINAL_TEXT                            MODIFIED_TEXT
---------------------------------------- ----------------------------------------
ambiguïté séquoia après déjà français    ambiguite sequoia apres deja francais