- All Superinterfaces:
QueryPart
,SelectFieldOrAsterisk
,Serializable
Asterisks (qualified and unqualified) are expressions that can be used
exclusively in SELECT
clauses and a few other clauses that
explicitly allow for asterisks, including RETURNING
on DML
statements. Asterisks are syntax sugar in SQL, which are expanded to a column
list by the parser once all the columns in the FROM
clause are
known.
Example:
// Assuming import static org.jooq.impl.DSL.*;
using(configuration)
.select(asterisk())
.from(ACTOR)
.fetch();
Instances can be created using DSL.asterisk()
.
- Author:
- Lukas Eder
- See Also:
-
Method Summary
Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList
<? extends Field<?>> $except()
Experimental query object model accessor method, see alsoQOM
.@NotNull Asterisk
The asterisk (* EXCEPT (fields)
) expression to be used inSELECT
clauses.@NotNull Asterisk
except
(Collection<? extends Field<?>> fields) The asterisk (*
) to be used inSELECT
clauses.@NotNull Asterisk
The asterisk (*
) to be used inSELECT
clauses.@NotNull Asterisk
The asterisk (*
) to be used inSELECT
clauses.
-
Method Details
-
except
The asterisk (* EXCEPT (fields)
) expression to be used inSELECT
clauses.This expression is a convenient way to select "all but some fields". Some dialects (e.g.
SQLDialect.H2
) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible. -
except
The asterisk (*
) to be used inSELECT
clauses.This expression is a convenient way to select "all but some fields". Some dialects (e.g.
SQLDialect.H2
) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible. -
except
The asterisk (*
) to be used inSELECT
clauses.This expression is a convenient way to select "all but some fields". Some dialects (e.g.
SQLDialect.H2
) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible. -
except
The asterisk (*
) to be used inSELECT
clauses.This expression is a convenient way to select "all but some fields". Some dialects (e.g.
SQLDialect.H2
) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible. -
$except
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk.
-