SELECT *
FROM JSON_TABLE(cReq,
'$' COLUMNS ( dep_id NUMBER(10) PATH '$.dep_id',
id NUMBER(10) PATH '$.id',
cli_codes varchar2(500) FORMAT JSON PATH '$.cli_codes'
)
) jsontable
INSERT INTO people (last_name, first_name, sex, birthday)
VALUES ('Иванов', 'Иван', 'm', TO_DATE('1999-04-04', 'YYYY-MM-DD'));
SELECT *
FROM test
ORDER BY CASE status WHEN 'cancelled'
THEN 1
ELSE 2
END;
SELECT t1.*
FROM table t1
WHERE EXISTS ( SELECT NULL
FROM table t2
WHERE t1.id <> t2.id -- выражение первичного ключа
AND t1.column = t2.column -- для всех полей, кроме первичного ключа
DELETE
FROM table t1
WHERE EXISTS ( SELECT NULL
FROM table t2
WHERE t1.id > t2.id -- оставить только запись с минимальным ID
AND t1.column = t2.column
SELECT value,
SUM(value = val1) total_1,
SUM(value = val2) total_2
FROM ( SELECT val1 value FROM test
UNION
SELECT val2 FROM test ) total
CROSS JOIN test
GROUP BY value
ORDER BY value;