org.jooq

Interface SelectConnectByAfterStartWithStep<R extends Record>

public interface SelectConnectByAfterStartWithStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

Example:

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

Its equivalent in jOOQ

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

Refer to the manual for more details

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
SelectConnectByAfterStartWithConditionStep<R>	connectBy(java.lang.Boolean condition) Deprecated. - 3.8.0 - [#4763] - Use connectBy(Condition) or connectBy(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.
SelectConnectByAfterStartWithConditionStep<R>	connectBy(Condition condition) Add an Oracle-specific CONNECT BY clause to the query
SelectConnectByAfterStartWithConditionStep<R>	connectBy(Field<java.lang.Boolean> condition) Add an Oracle-specific CONNECT BY clause to the query
SelectConnectByAfterStartWithConditionStep<R>	connectBy(SQL sql) Add an Oracle-specific CONNECT BY clause to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConnectByAfterStartWithConditionStep<R>	connectBy(java.lang.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.
SelectConnectByAfterStartWithConditionStep<R>	connectBy(java.lang.String sql, java.lang.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.
SelectConnectByAfterStartWithConditionStep<R>	connectBy(java.lang.String sql, QueryPart... parts) Add an Oracle-specific CONNECT BY clause to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConnectByAfterStartWithConditionStep<R>	connectByNoCycle(java.lang.Boolean condition) Deprecated. - 3.8.0 - [#4763] - Use connectByNoCycle(Condition) or connectByNoCycle(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.
SelectConnectByAfterStartWithConditionStep<R>	connectByNoCycle(Condition condition) Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
SelectConnectByAfterStartWithConditionStep<R>	connectByNoCycle(Field<java.lang.Boolean> condition) Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
SelectConnectByAfterStartWithConditionStep<R>	connectByNoCycle(SQL 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.
SelectConnectByAfterStartWithConditionStep<R>	connectByNoCycle(java.lang.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.
SelectConnectByAfterStartWithConditionStep<R>	connectByNoCycle(java.lang.String sql, java.lang.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.
SelectConnectByAfterStartWithConditionStep<R>	connectByNoCycle(java.lang.String sql, QueryPart... parts) Add an Oracle-specific CONNECT BY NOCYCLE clause to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

Method Detail

connectBy

@Support(value={CUBRID,INFORMIX,ORACLE})
SelectConnectByAfterStartWithConditionStep<R> connectBy(Condition condition)

Add an Oracle-specific CONNECT BY clause to the query

connectBy

@Support(value={CUBRID,INFORMIX,ORACLE})
SelectConnectByAfterStartWithConditionStep<R> connectBy(Field<java.lang.Boolean> condition)

Add an Oracle-specific CONNECT BY clause to the query

connectBy

@Deprecated
 @Support(value={CUBRID,INFORMIX,ORACLE})
SelectConnectByAfterStartWithConditionStep<R> connectBy(java.lang.Boolean condition)

Deprecated. - 3.8.0 - [#4763] - Use connectBy(Condition) or connectBy(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.

Add an Oracle-specific CONNECT BY clause to the query

connectBy

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectBy(SQL sql)

Add an Oracle-specific 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!

See Also:

DSL.condition(SQL), SQL

connectBy

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectBy(java.lang.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. 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!

See Also:

DSL.condition(String), SQL

connectBy

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectBy(java.lang.String sql,
                                                                                                              java.lang.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. 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!

See Also:

DSL.condition(String, Object...), DSL.sql(String, Object...), SQL

connectBy

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectBy(java.lang.String sql,
                                                                                                              QueryPart... parts)

Add an Oracle-specific 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!

See Also:

DSL.condition(String, QueryPart...), DSL.sql(String, QueryPart...), SQL

connectByNoCycle

@Support(value={CUBRID,INFORMIX,ORACLE})
SelectConnectByAfterStartWithConditionStep<R> connectByNoCycle(Condition condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

connectByNoCycle

@Support(value={CUBRID,INFORMIX,ORACLE})
SelectConnectByAfterStartWithConditionStep<R> connectByNoCycle(Field<java.lang.Boolean> condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

connectByNoCycle

@Deprecated
 @Support(value={CUBRID,INFORMIX,ORACLE})
SelectConnectByAfterStartWithConditionStep<R> connectByNoCycle(java.lang.Boolean condition)

Deprecated. - 3.8.0 - [#4763] - Use connectByNoCycle(Condition) or connectByNoCycle(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query

connectByNoCycle

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectByNoCycle(SQL 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. 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!

See Also:

DSL.condition(SQL), SQL

connectByNoCycle

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectByNoCycle(java.lang.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. 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!

See Also:

DSL.condition(String), SQL

connectByNoCycle

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectByNoCycle(java.lang.String sql,
                                                                                                                     java.lang.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. 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!

See Also:

DSL.condition(String, Object...), DSL.sql(String, Object...), SQL

connectByNoCycle

@Support(value={CUBRID,INFORMIX,ORACLE})
 @PlainSQL
SelectConnectByAfterStartWithConditionStep<R> connectByNoCycle(java.lang.String sql,
                                                                                                                     QueryPart... parts)

Add an Oracle-specific 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!

See Also:

DSL.condition(String, QueryPart...), DSL.sql(String, QueryPart...), SQL