-
- All Superinterfaces:
QueryPart
,SelectFieldOrAsterisk
,Serializable
public interface Asterisk extends SelectFieldOrAsterisk
An unqualified asterisk.Asterisks (qualified and unqualified) are expressions that can be used exclusively in
SELECT
clauses and a few other clauses that explicitly allow for asterisks, includingRETURNING
on DML statements. Asterisks are syntax sugar in SQL, which are expanded to a column list by the parser once all the columns in theFROM
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:
Table.asterisk()
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description Asterisk
except(String... fieldNames)
The asterisk (* EXCEPT (fields)
) expression to be used inSELECT
clauses.Asterisk
except(Field<?>... fields)
The asterisk (*
) to be used inSELECT
clauses.Asterisk
except(Name... fieldNames)
The asterisk (*
) to be used inSELECT
clauses.
-
-
-
Method Detail
-
except
@Support Asterisk except(String... fieldNames)
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
@Support Asterisk except(Name... fieldNames)
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
@Support Asterisk except(Field<?>... fields)
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.
-
-