DELETE .. RETURNING

deleteFrom(BOOK).where(BOOK.ID.eq(1)).returningResult(BOOK.TITLE)

DELETE FROM BOOK
WHERE BOOK.ID = 1
RETURNING BOOK.TITLE

SELECT TITLE
FROM OLD TABLE (
  DELETE FROM BOOK
  WHERE BOOK.ID = 1
) BOOK

DELETE FROM BOOK
WHERE BOOK.ID = 1
RETURNING TITLE

DECLARE
  o0 DBMS_SQL.VARCHAR2_TABLE;
  c0 sys_refcursor;
BEGIN
  DELETE FROM BOOK
  WHERE BOOK.ID = 1
  RETURNING BOOK.TITLE
  BULK COLLECT INTO o0;
  ? := SQL%ROWCOUNT;
  OPEN c0 FOR SELECT * FROM TABLE(o0);
  ? := c0;
END;

DELETE FROM BOOK
OUTPUT deleted.TITLE
WHERE BOOK.ID = 1

/* UNSUPPORTED */

使用 jOOQ 3.21 生成。早期 jOOQ 版本的支持可能有所不同。 在我们的网站上翻译您自己的 SQL