Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE banka_odeme (
    banka_id,
    banka_ad,
    banka_tutar,
    aciklama,
    banka_ismi
  ) AS
SELECT 1, 'XXXXXXX', 1, '1', 'XXXXXXX' FROM DUAL
1 rows affected

CREATE TABLE woo_orders (first_name, last_name, total, id) AS
SELECT 'A', 'A', 1, 1 FROM DUAL UNION ALL
SELECT 'B', 'B', 2, 2 FROM DUAL;
2 rows affected

DECLARE
  v_sql VARCHAR2(200);
  v_id  BANKA_ODEME.BANKA_ID%TYPE;
BEGIN
  SELECT MAX(banka_id) + 1
  INTO   v_id
  FROM   banka_odeme;

  v_sql := 'CREATE SEQUENCE banka_odeme__banka_id__seq START WITH ' || v_id;
  EXECUTE IMMEDIATE v_sql;
END;
/
1 rows affected

MERGE INTO banka_odeme b
USING woo_orders w
ON (b.aciklama = TO_CHAR(w.id))
WHEN NOT MATCHED THEN
  INSERT (
    banka_id,
    banka_ad,
    banka_tutar,
    aciklama,
    banka_ismi
  ) VALUES (
    banka_odeme__banka_id__seq.NEXTVAL,
    w.first_name || ' ' || w.last_name,
    w.total,
    TO_CHAR(w.id),
    'SiPay'
  );
1 rows affected

SELECT * FROM banka_odeme;


BANKA_ID
BANKA_AD
BANKA_TUTAR
ACIKLAMA
BANKA_ISMI


1
XXXXXXX
1
1
XXXXXXX

3
B B
2
2
SiPay