-
- 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
SELECTclauses and a few other clauses that explicitly allow for asterisks, includingRETURNINGon DML statements. Asterisks are syntax sugar in SQL, which are expanded to a column list by the parser once all the columns in theFROMclause 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 Asteriskexcept(String... fieldNames)The asterisk (* EXCEPT (fields)) expression to be used inSELECTclauses.Asteriskexcept(Field<?>... fields)The asterisk (*) to be used inSELECTclauses.Asteriskexcept(Name... fieldNames)The asterisk (*) to be used inSELECTclauses.
-
-
-
Method Detail
-
except
@Support Asterisk except(String... fieldNames)
The asterisk (* EXCEPT (fields)) expression to be used inSELECTclauses.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 inSELECTclauses.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 inSELECTclauses.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.
-
-