常用sql

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);