Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Interface and Description |
---|---|
interface |
SelectSelectStep<R extends Record>
|
Modifier and Type | Method and Description |
---|---|
SelectFromStep<R> |
SelectFromStep.hint(String hint)
Add an Oracle-style hint to the preceding select clause
Example:
DSLContext create = DSL.using(configuration);
create.select(field1, field2)
.hint("/*+ALL_ROWS*/")
.from(table1)
.fetch();
You can also use this clause for any other database, that accepts hints
or options at the same syntactic location, e.g. for MySQL's
SQL_CALC_FOUND_ROWS option:
create.select(field1, field2)
.hint("SQL_CALC_FOUND_ROWS")
.from(table1)
.fetch();
The outcome of such a query is this:
SELECT [hint] field1, field2 FROM table1
For SQL Server style table hints, see Table.with(String) |
Copyright © 2013. All Rights Reserved.