CREATE VIEW

// Create a new view
create.createView("books_and_authors", "author_id", "first_name", "last_name", "book_id", "title")
      .as(select(AUTHOR.ID, AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME, BOOK.ID, BOOK.TITLE)
          .from(AUTHOR)
          .join(BOOK).on(AUTHOR.ID.eq(BOOK.AUTHOR_ID)))
      .execute();

createView("a", "id").as(select(AUTHOR.ID).from(AUTHOR))

CREATE VIEW a(id)
AS
SELECT AUTHOR.ID
FROM AUTHOR

CREATE VIEW a
AS
SELECT t.id
FROM (
  SELECT AUTHOR.ID id
  FROM AUTHOR
) t

CREATE VIEW a
SQL SECURITY INVOKER
AS
SELECT t.id
FROM (
  SELECT AUTHOR.ID id
  FROM AUTHOR
) t

CREATE VIEW a
AS
SELECT t.id
FROM (
  SELECT AUTHOR.ID
  FROM AUTHOR
) t (id)

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website