oracle:
SELECT * from BASE_AREA
where AREA_NAME != '中国'
start with BASE_AREA_ID = '5d1aa479cc0e48128a9011b0c3baad42'CONNECT by prior PARENT_ID= BASE_AREA_ID (父节点=子节点,向上查询,反之向下查询)
ORDER BY sort
MERGE INTO hsd_test t1 USING (
SELECT
2 ID,
'jack1' NAME
FROM
dual
) t2 ON (t1. ID = t2. ID)
WHEN MATCHED THEN
UPDATE
SET t1. NAME = t2. NAME
WHEN NOT MATCHED THEN
INSERT (ID, NAME)
VALUES
(t2. ID, t2.NAME);