|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface SelectConnectByStep
This type is used for the Select
's DSL API when selecting generic
Record
types.
Example:
Its equivalent in jOOQ
-- get all authors' first and last names, and the number
-- of books they've written in German, if they have written
-- more than five books in German in the last three years
-- (from 2011), and sort those authors by last names
-- limiting results to the second and third row
SELECT T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME, COUNT(*)
FROM T_AUTHOR
JOIN T_BOOK ON T_AUTHOR.ID = T_BOOK.AUTHOR_ID
WHERE T_BOOK.LANGUAGE = 'DE'
AND T_BOOK.PUBLISHED > '2008-01-01'
GROUP BY T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME
HAVING COUNT(*) > 5
ORDER BY T_AUTHOR.LAST_NAME ASC NULLS FIRST
LIMIT 2
OFFSET 1
FOR UPDATE
OF FIRST_NAME, LAST_NAME
NO WAIT
Refer to the manual for more details
create.select(TAuthor.FIRST_NAME, TAuthor.LAST_NAME, create.count())
.from(T_AUTHOR)
.join(T_BOOK).on(TBook.AUTHOR_ID.equal(TAuthor.ID))
.where(TBook.LANGUAGE.equal("DE"))
.and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
.groupBy(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.having(create.count().greaterThan(5))
.orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
.limit(2)
.offset(1)
.forUpdate()
.of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.noWait();
Method Summary | |
---|---|
SelectConnectByConditionStep |
connectBy(Condition condition)
Add an Oracle-specific CONNECT BY clause to the query |
SelectConnectByConditionStep |
connectBy(String sql)
Add an Oracle-specific CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep |
connectBy(String sql,
Object... bindings)
Add an Oracle-specific CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep |
connectByNoCycle(Condition condition)
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query |
SelectConnectByConditionStep |
connectByNoCycle(String sql)
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SelectConnectByConditionStep |
connectByNoCycle(String sql,
Object... bindings)
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
Methods inherited from interface org.jooq.SelectGroupByStep |
---|
groupBy, groupBy |
Methods inherited from interface org.jooq.SelectHavingStep |
---|
having, having, having, having |
Methods inherited from interface org.jooq.SelectOrderByStep |
---|
orderBy, orderBy, orderBy, orderBy |
Methods inherited from interface org.jooq.SelectLimitStep |
---|
limit, limit, limit, limit, limit, limit |
Methods inherited from interface org.jooq.SelectForUpdateStep |
---|
forShare, forUpdate |
Methods inherited from interface org.jooq.SelectFinalStep |
---|
getQuery |
Methods inherited from interface org.jooq.Select |
---|
except, getSelect, intersect, union, unionAll |
Methods inherited from interface org.jooq.ResultQuery |
---|
bind, bind, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchInto, fetchInto, fetchInto, fetchLater, fetchLater, fetchLazy, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneMap, fetchResultSet, getRecordType, getResult |
Methods inherited from interface org.jooq.Query |
---|
execute, getBindValues, getParam, getParams, getSQL, getSQL |
Methods inherited from interface org.jooq.Attachable |
---|
attach |
Methods inherited from interface org.jooq.Adapter |
---|
internalAPI |
Methods inherited from interface org.jooq.TableLike |
---|
asTable, asTable |
Methods inherited from interface org.jooq.FieldLike |
---|
asField, asField |
Methods inherited from interface org.jooq.FieldProvider |
---|
getField, getField, getField, getFields, getIndex |
Method Detail |
---|
SelectConnectByConditionStep connectBy(Condition condition)
CONNECT BY
clause to the query
SelectConnectByConditionStep connectBy(String sql)
CONNECT BY
clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
SelectConnectByConditionStep connectBy(String sql, Object... bindings)
CONNECT BY
clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
SelectConnectByConditionStep connectByNoCycle(Condition condition)
CONNECT BY NOCYCLE
clause to the
query
SelectConnectByConditionStep connectByNoCycle(String sql)
CONNECT BY NOCYCLE
clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
SelectConnectByConditionStep connectByNoCycle(String sql, Object... bindings)
CONNECT BY NOCYCLE
clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |