<O extends TableRecord<O>> O | 
UpdatableRecord.fetchChild(ForeignKey<O,R> key) | 
 Fetch a child record of this record, given a foreign key. 
 | 
R | 
DeleteResultStep.fetchOne() | 
 | 
Record | 
DSLContext.fetchOne(java.lang.String sql) | 
 Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchOne(java.lang.String sql,
        java.lang.Object... bindings) | 
 Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchOne(java.lang.String sql,
        QueryPart... parts) | 
 Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchOne(java.sql.ResultSet rs) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
Record | 
DSLContext.fetchOne(java.sql.ResultSet rs,
        java.lang.Class<?>... types) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
Record | 
DSLContext.fetchOne(java.sql.ResultSet rs,
        DataType<?>... types) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
Record | 
DSLContext.fetchOne(java.sql.ResultSet rs,
        Field<?>... fields) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
<R extends Record> R | 
DSLContext.fetchOne(ResultQuery<R> query) | 
Execute a  ResultQuery in the context of this  DSLContext and return
 a record.  
 | 
Record | 
DSLContext.fetchOne(SQL sql) | 
 Execute a new query holding plain SQL. 
 | 
<R extends Record> R | 
DSLContext.fetchOne(Table<R> table) | 
 Execute and return zero or one record for
  
 | 
<R extends Record> R | 
DSLContext.fetchOne(Table<R> table,
        java.util.Collection<? extends Condition> conditions) | 
 Execute and return zero or one record for
  
 | 
<R extends Record> R | 
DSLContext.fetchOne(Table<R> table,
        Condition condition) | 
 Execute and return zero or one record for
  
 | 
<R extends Record> R | 
DSLContext.fetchOne(Table<R> table,
        Condition... conditions) | 
 Execute and return zero or one record for
  
 | 
R | 
InsertResultStep.fetchOne() | 
 | 
R | 
ResultQuery.fetchOne() | 
 Execute the query and return at most one resulting record. 
 | 
java.lang.Object | 
ResultQuery.fetchOne(int fieldIndex) | 
 Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
<T> T | 
ResultQuery.fetchOne(int fieldIndex,
        java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
<U> U | 
ResultQuery.fetchOne(int fieldIndex,
        Converter<?,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
java.lang.Object | 
ResultQuery.fetchOne(java.lang.String fieldName) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<T> T | 
ResultQuery.fetchOne(java.lang.String fieldName,
        java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<U> U | 
ResultQuery.fetchOne(java.lang.String fieldName,
        Converter<?,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<T> T | 
ResultQuery.fetchOne(Field<?> field,
        java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field from the generated result. 
 | 
<T> T | 
ResultQuery.fetchOne(Field<T> field) | 
 Execute the query and return at most one resulting value for a
 field from the generated result. 
 | 
<T,U> U | 
ResultQuery.fetchOne(Field<T> field,
        Converter<? super T,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field from the generated result. 
 | 
java.lang.Object | 
ResultQuery.fetchOne(Name fieldName) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<T> T | 
ResultQuery.fetchOne(Name fieldName,
        java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<U> U | 
ResultQuery.fetchOne(Name fieldName,
        Converter<?,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<E> E | 
ResultQuery.fetchOne(RecordMapper<? super R,E> mapper) | 
 Execute the query and return at most one resulting value into a
 custom mapper callback. 
 | 
R | 
UpdateResultStep.fetchOne() | 
 | 
java.lang.Object[] | 
ResultQuery.fetchOneArray() | 
 Execute the query and return at most one resulting record as an array 
 | 
<E> E | 
ResultQuery.fetchOneInto(java.lang.Class<? extends E> type) | 
 Map resulting records onto a custom type. 
 | 
<Z extends Record> Z | 
ResultQuery.fetchOneInto(Table<Z> table) | 
 Map resulting records onto a custom record. 
 | 
java.util.Map<java.lang.String,java.lang.Object> | 
ResultQuery.fetchOneMap() | 
 Execute the query and return at most one resulting record as a name/value
 map. 
 | 
java.util.Optional<R> | 
DeleteResultStep.fetchOptional() | 
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(java.lang.String sql) | 
 Execute a new query holding plain SQL. 
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(java.lang.String sql,
             java.lang.Object... bindings) | 
 Execute a new query holding plain SQL. 
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(java.lang.String sql,
             QueryPart... parts) | 
 Execute a new query holding plain SQL. 
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(java.sql.ResultSet rs) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(java.sql.ResultSet rs,
             java.lang.Class<?>... types) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(java.sql.ResultSet rs,
             DataType<?>... types) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(java.sql.ResultSet rs,
             Field<?>... fields) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
<R extends Record> java.util.Optional<R> | 
DSLContext.fetchOptional(ResultQuery<R> query) | 
Execute a  ResultQuery in the context of this  DSLContext and return
 a record.  
 | 
java.util.Optional<Record> | 
DSLContext.fetchOptional(SQL sql) | 
 Execute a new query holding plain SQL. 
 | 
<R extends Record> java.util.Optional<R> | 
DSLContext.fetchOptional(Table<R> table) | 
 Execute and return zero or one record for
  
 | 
<R extends Record> java.util.Optional<R> | 
DSLContext.fetchOptional(Table<R> table,
             java.util.Collection<? extends Condition> conditions) | 
 Execute and return zero or one record for
  
 | 
<R extends Record> java.util.Optional<R> | 
DSLContext.fetchOptional(Table<R> table,
             Condition condition) | 
 Execute and return zero or one record for
  
 | 
<R extends Record> java.util.Optional<R> | 
DSLContext.fetchOptional(Table<R> table,
             Condition... conditions) | 
 Execute and return zero or one record for
  
 | 
java.util.Optional<R> | 
InsertResultStep.fetchOptional() | 
 | 
java.util.Optional<R> | 
ResultQuery.fetchOptional() | 
 Execute the query and return at most one resulting record. 
 | 
java.util.Optional<?> | 
ResultQuery.fetchOptional(int fieldIndex) | 
 Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
<T> java.util.Optional<T> | 
ResultQuery.fetchOptional(int fieldIndex,
             java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
<U> java.util.Optional<U> | 
ResultQuery.fetchOptional(int fieldIndex,
             Converter<?,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field index from the generated result. 
 | 
java.util.Optional<?> | 
ResultQuery.fetchOptional(java.lang.String fieldName) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<T> java.util.Optional<T> | 
ResultQuery.fetchOptional(java.lang.String fieldName,
             java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<U> java.util.Optional<U> | 
ResultQuery.fetchOptional(java.lang.String fieldName,
             Converter<?,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<T> java.util.Optional<T> | 
ResultQuery.fetchOptional(Field<?> field,
             java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field from the generated result. 
 | 
<T> java.util.Optional<T> | 
ResultQuery.fetchOptional(Field<T> field) | 
 Execute the query and return at most one resulting value for a
 field from the generated result. 
 | 
<T,U> java.util.Optional<U> | 
ResultQuery.fetchOptional(Field<T> field,
             Converter<? super T,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field from the generated result. 
 | 
java.util.Optional<?> | 
ResultQuery.fetchOptional(Name fieldName) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<T> java.util.Optional<T> | 
ResultQuery.fetchOptional(Name fieldName,
             java.lang.Class<? extends T> type) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<U> java.util.Optional<U> | 
ResultQuery.fetchOptional(Name fieldName,
             Converter<?,? extends U> converter) | 
 Execute the query and return at most one resulting value for a
 field name from the generated result. 
 | 
<E> java.util.Optional<E> | 
ResultQuery.fetchOptional(RecordMapper<? super R,E> mapper) | 
 Execute the query and return at most one resulting value into a
 custom mapper callback. 
 | 
java.util.Optional<R> | 
UpdateResultStep.fetchOptional() | 
 | 
java.util.Optional<java.lang.Object[]> | 
ResultQuery.fetchOptionalArray() | 
 Execute the query and return at most one resulting record as an array. 
 | 
<E> java.util.Optional<E> | 
ResultQuery.fetchOptionalInto(java.lang.Class<? extends E> type) | 
 Map resulting records onto a custom type. 
 | 
<Z extends Record> java.util.Optional<Z> | 
ResultQuery.fetchOptionalInto(Table<Z> table) | 
 Map resulting records onto a custom record. 
 | 
java.util.Optional<java.util.Map<java.lang.String,java.lang.Object>> | 
ResultQuery.fetchOptionalMap() | 
 Execute the query and return at most one resulting record as a name/value
 map. 
 | 
java.util.Optional<?> | 
DSLContext.fetchOptionalValue(java.lang.String sql) | 
 Execute a new query holding plain SQL. 
 | 
java.util.Optional<?> | 
DSLContext.fetchOptionalValue(java.lang.String sql,
                  java.lang.Object... bindings) | 
 Execute a new query holding plain SQL. 
 | 
java.util.Optional<?> | 
DSLContext.fetchOptionalValue(java.lang.String sql,
                  QueryPart... parts) | 
 Execute a new query holding plain SQL. 
 | 
java.util.Optional<?> | 
DSLContext.fetchOptionalValue(java.sql.ResultSet rs) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T> java.util.Optional<T> | 
DSLContext.fetchOptionalValue(java.sql.ResultSet rs,
                  java.lang.Class<T> type) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T> java.util.Optional<T> | 
DSLContext.fetchOptionalValue(java.sql.ResultSet rs,
                  DataType<T> type) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T> java.util.Optional<T> | 
DSLContext.fetchOptionalValue(java.sql.ResultSet rs,
                  Field<T> field) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T,R extends Record1<T>> java.util.Optional<T> | 
DSLContext.fetchOptionalValue(ResultQuery<R> query) | 
Execute a  ResultQuery in the context of this
  DSLContext and return a single value.  
 | 
java.util.Optional<?> | 
DSLContext.fetchOptionalValue(SQL sql) | 
 Execute a new query holding plain SQL. 
 | 
<T> java.util.Optional<T> | 
DSLContext.fetchOptionalValue(TableField<?,T> field) | 
Execute a  ResultQuery in the context of this
  DSLContext and return a single value.  
 | 
Record | 
DSLContext.fetchSingle(java.lang.String sql) | 
 Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchSingle(java.lang.String sql,
           java.lang.Object... bindings) | 
 Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchSingle(java.lang.String sql,
           QueryPart... parts) | 
 Execute a new query holding plain SQL. 
 | 
Record | 
DSLContext.fetchSingle(java.sql.ResultSet rs) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
Record | 
DSLContext.fetchSingle(java.sql.ResultSet rs,
           java.lang.Class<?>... types) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
Record | 
DSLContext.fetchSingle(java.sql.ResultSet rs,
           DataType<?>... types) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
Record | 
DSLContext.fetchSingle(java.sql.ResultSet rs,
           Field<?>... fields) | 
Fetch a record from a JDBC  ResultSet and transform it to a jOOQ
  Record.  
 | 
<R extends Record> R | 
DSLContext.fetchSingle(ResultQuery<R> query) | 
Execute a  ResultQuery in the context of this  DSLContext and return
 a record.  
 | 
Record | 
DSLContext.fetchSingle(SQL sql) | 
 Execute a new query holding plain SQL. 
 | 
<R extends Record> R | 
DSLContext.fetchSingle(Table<R> table) | 
 Execute and return exactly one record for
  
 | 
<R extends Record> R | 
DSLContext.fetchSingle(Table<R> table,
           java.util.Collection<? extends Condition> conditions) | 
 Execute and return exactly one record for
  
 | 
<R extends Record> R | 
DSLContext.fetchSingle(Table<R> table,
           Condition condition) | 
 Execute and return exactly one record for
  
 | 
<R extends Record> R | 
DSLContext.fetchSingle(Table<R> table,
           Condition... conditions) | 
 Execute and return exactly one record for
  
 | 
R | 
ResultQuery.fetchSingle() | 
 Execute the query and return exactly one resulting record. 
 | 
java.lang.Object | 
ResultQuery.fetchSingle(int fieldIndex) | 
 Execute the query and return exactly one resulting value for a
 field index from the generated result. 
 | 
<T> T | 
ResultQuery.fetchSingle(int fieldIndex,
           java.lang.Class<? extends T> type) | 
 Execute the query and return exactly one resulting value for a
 field index from the generated result. 
 | 
<U> U | 
ResultQuery.fetchSingle(int fieldIndex,
           Converter<?,? extends U> converter) | 
 Execute the query and return exactly one resulting value for a
 field index from the generated result. 
 | 
java.lang.Object | 
ResultQuery.fetchSingle(java.lang.String fieldName) | 
 Execute the query and return exactly one resulting value for a
 field name from the generated result. 
 | 
<T> T | 
ResultQuery.fetchSingle(java.lang.String fieldName,
           java.lang.Class<? extends T> type) | 
 Execute the query and return exactly one resulting value for a
 field name from the generated result. 
 | 
<U> U | 
ResultQuery.fetchSingle(java.lang.String fieldName,
           Converter<?,? extends U> converter) | 
 Execute the query and return exactly one resulting value for a
 field name from the generated result. 
 | 
<T> T | 
ResultQuery.fetchSingle(Field<?> field,
           java.lang.Class<? extends T> type) | 
 Execute the query and return exactly one resulting value for a
 field from the generated result. 
 | 
<T> T | 
ResultQuery.fetchSingle(Field<T> field) | 
 Execute the query and return exactly one resulting value for a field from
 the generated result. 
 | 
<T,U> U | 
ResultQuery.fetchSingle(Field<T> field,
           Converter<? super T,? extends U> converter) | 
 Execute the query and return exactly one resulting value for a
 field from the generated result. 
 | 
java.lang.Object | 
ResultQuery.fetchSingle(Name fieldName) | 
 Execute the query and return exactly one resulting value for a
 field name from the generated result. 
 | 
<T> T | 
ResultQuery.fetchSingle(Name fieldName,
           java.lang.Class<? extends T> type) | 
 Execute the query and return exactly one resulting value for a
 field name from the generated result. 
 | 
<U> U | 
ResultQuery.fetchSingle(Name fieldName,
           Converter<?,? extends U> converter) | 
 Execute the query and return exactly one resulting value for a
 field name from the generated result. 
 | 
<E> E | 
ResultQuery.fetchSingle(RecordMapper<? super R,E> mapper) | 
 Execute the query and return exactly one resulting value into a
 custom mapper callback. 
 | 
java.lang.Object[] | 
ResultQuery.fetchSingleArray() | 
 Execute the query and return exactly one resulting record as an array 
 | 
<E> E | 
ResultQuery.fetchSingleInto(java.lang.Class<? extends E> type) | 
 Map resulting records onto a custom type. 
 | 
<Z extends Record> Z | 
ResultQuery.fetchSingleInto(Table<Z> table) | 
 Map resulting records onto a custom record. 
 | 
java.util.Map<java.lang.String,java.lang.Object> | 
ResultQuery.fetchSingleMap() | 
 Execute the query and return exactly one resulting record as a name/value
 map. 
 | 
java.lang.Object | 
DSLContext.fetchValue(java.lang.String sql) | 
 Execute a new query holding plain SQL. 
 | 
java.lang.Object | 
DSLContext.fetchValue(java.lang.String sql,
          java.lang.Object... bindings) | 
 Execute a new query holding plain SQL. 
 | 
java.lang.Object | 
DSLContext.fetchValue(java.lang.String sql,
          QueryPart... parts) | 
 Execute a new query holding plain SQL. 
 | 
java.lang.Object | 
DSLContext.fetchValue(java.sql.ResultSet rs) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T> T | 
DSLContext.fetchValue(java.sql.ResultSet rs,
          java.lang.Class<T> type) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T> T | 
DSLContext.fetchValue(java.sql.ResultSet rs,
          DataType<T> type) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T> T | 
DSLContext.fetchValue(java.sql.ResultSet rs,
          Field<T> field) | 
 Fetch a record from a JDBC ResultSet and return the only
 contained value. 
 | 
<T,R extends Record1<T>> T | 
DSLContext.fetchValue(ResultQuery<R> query) | 
Execute a  ResultQuery in the context of this
  DSLContext and return a single value.  
 | 
java.lang.Object | 
DSLContext.fetchValue(SQL sql) | 
 Execute a new query holding plain SQL. 
 | 
<T> T | 
DSLContext.fetchValue(Table<? extends Record1<T>> table) | 
 Fetch a single value from a single column table. 
 | 
<T> T | 
DSLContext.fetchValue(TableField<?,T> field) | 
Execute a  ResultQuery in the context of this
  DSLContext and return a single value.  
 |