Top Fields Constructors Methods
org.jooq.impl

pack-priv final Class Nvl2<T>

extends AbstractField<T>
implements QOM.Nvl2<T>
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.Nvl2, org.jooq.impl.QOM.UOperator3, org.jooq.impl.QOM.UOperator, org.jooq.QueryPart, java.io.Serializable, org.jooq.Field, org.jooq.TableElement, org.jooq.Named, org.jooq.FieldOrConstraint, org.jooq.FieldOrRowOrSelect, org.jooq.FieldOrRow, org.jooq.OrderField, org.jooq.GroupField, org.jooq.SelectField, org.jooq.Typed, org.jooq.SelectFieldOrAsterisk
Static Imports
org.jooq.SQLDialect.MARIADB, org.jooq.impl.DSL.function, .DSL.iif, .Names.N_NVL2

Deprecated

as a consequence of AbstractField and QOM.Nvl2 being deprecated. See corresponding docs for further information.

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
private final Field<?>
arg1

Deprecated as a consequence of Field being deprecated.
private final Field<T>
arg2

Deprecated as a consequence of Field being deprecated.
private final Field<T>
arg3

Deprecated as a consequence of Field being deprecated.

Constructor Summary

AccessConstructor and Description
pack-priv
Nvl2(Field<?> arg1, Field<T> arg2, Field<T> arg3)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final Field<?>
$arg1()

Implements org.jooq.impl.QOM.UOperator3.$arg1.

Deprecated as a consequence of Field being deprecated.
public final Field<T>
$arg2()

Implements org.jooq.impl.QOM.UOperator3.$arg2.

Deprecated as a consequence of Field being deprecated.
public final Field<T>
$arg3()

Implements org.jooq.impl.QOM.UOperator3.$arg3.

Deprecated as a consequence of Field being deprecated.
public final Function3<? super Field<?>, ? super Field<T>, ? super Field<T>, ? extends QOM.Nvl2<T>>
public final void
accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
private void
private final void
Inherited from org.jooq.impl.AbstractField:
$alias$aliasedabsacosaddaddasasasasascasciiasinatanatan2atan2avgavgOverbetweenbetweenbetweenbetweenbetweenSymmetricbetweenSymmetricbetweenSymmetricbetweenSymmetricbitAndbitAndbitLengthbitNandbitNandbitNorbitNorbitNotbitOrbitOrbitXNorbitXNorbitXorbitXorcastcastcastceilchangedcharLengthclausescoalescecoalescecoercecoercecoercecollatecollatecollatecommentcommentcomparecomparecomparecompareconcatconcatconcatcontainscontainscontainsIgnoreCasecontainsIgnoreCaseconvertconvertconvertconvertFromconvertFromconvertToconvertTocoscoshcotcothcountcountDistinctcountOverdecodedecodedecodedecodedegdescdivdivdividedivideendsWithendsWithendsWithIgnoreCaseendsWithIgnoreCaseeqeqeqeqequalequalequalequalequalIgnoreCaseequalIgnoreCaseexpextractfieldfirstValuefloorfromgegegegegetgetValuegreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterThangreaterThangreaterThangreaterThangreatestgreatestgtgtgtgtinininininisDistinctFromisDistinctFromisDistinctFromisDocumentisFalseisJsonisNotDistinctFromisNotDistinctFromisNotDistinctFromisNotDocumentisNotJsonisNotNullisNullisNullableisPossiblyNullableisTruelaglaglaglaglastValueleleleleleadleadleadleadleastleastlengthlessOrEquallessOrEquallessOrEquallessOrEquallessThanlessThanlessThanlessThanlikelikelikelikelikelikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeRegexlikeRegexlnloglowerlpadlpadlpadlpadltltltltltrimmaxmaxOvermedianminminOverminusminusmodmodmodulomodulomulmulmultiplymultiplynenenenenegnotBetweennotBetweennotBetweennotBetweennotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotContainsnotContainsnotContainsIgnoreCasenotContainsIgnoreCasenotEqualnotEqualnotEqualnotEqualnotEqualIgnoreCasenotEqualIgnoreCasenotInnotInnotInnotInnotInnotLikenotLikenotLikenotLikenotLikenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeRegexnotLikeRegexnotSimilarTonotSimilarTonotSimilarTonotSimilarTonotSimilarTonullifnullifnullsFirstnullsLastnvlnvlnvl2nvl2octetLengthoriginalparenthesisedpluspluspositionpositionpowpowpowerpowerprojectionSizeradremremrepeatrepeatreplacereplacereplacereplaceresetroundroundrpadrpadrpadrpadrtrimshlshlshrshrsignsimilarTosimilarTosimilarTosimilarTosimilarTosinsinhsortsortsortAscsortAscsortDefaultsortDescsortDescsqrtstartsWithstartsWithstartsWithIgnoreCasestartsWithIgnoreCasestddevPopstddevPopOverstddevSampstddevSampOversubsubsubstringsubstringsubstringsubstringsubtractsubtractsumsumOvertantanhtimestimestrimunaryMinusunaryPlusuppervarPopvarPopOvervarSampvarSampOver

Field Detail

arg1back to summary
private final Field<?> arg1

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

arg2back to summary
private final Field<T> arg2

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

arg3back to summary
private final Field<T> arg3

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Constructor Detail

Nvl2back to summary
pack-priv Nvl2(Field<?> arg1, Field<T> arg2, Field<T> arg3)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Method Detail

$arg1back to summary
public final Field<?> $arg1()

Implements org.jooq.impl.QOM.UOperator3.$arg1.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Annotations
@Override
$arg2back to summary
public final Field<T> $arg2()

Implements org.jooq.impl.QOM.UOperator3.$arg2.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Annotations
@Override
$arg3back to summary
public final Field<T> $arg3()

Implements org.jooq.impl.QOM.UOperator3.$arg3.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Annotations
@Override
$constructorback to summary
public final Function3<? super Field<?>, ? super Field<T>, ? super Field<T>, ? extends QOM.Nvl2<T>> $constructor()

Implements org.jooq.impl.QOM.UOperator3.$constructor.

Annotations
@Override
acceptback to summary
public final void accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override
acceptCaseback to summary
private void acceptCase(Context<?> ctx)
acceptDefaultback to summary
private final void acceptDefault(Context<?> ctx)