MergeMethodDefinition (Exasol SQL Statement Builder 4.5.3 API)

java.lang.Object
- com.exasol.sql.AbstractFragment
- - com.exasol.sql.dml.merge.MergeMethodDefinition

All Implemented Interfaces:

Fragment

Direct Known Subclasses:

MergeDeleteClause, MergeUpdateClause
```
public abstract class MergeMethodDefinition
extends AbstractFragment
```
Abstract base class for merge method definitions like WHEN MATCHED THEN UPDATE.

Field Summary

Fields
Modifier and Type Field Description

protected WhereClause where
WHERE clause
- Fields inherited from class com.exasol.sql.AbstractFragment
  root

Constructor Summary

Constructors
Modifier Constructor Description

protected MergeMethodDefinition(Fragment root)
Create the abstract base for a merge method definition.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`WhereClause`	`getWhere()`	Get the `WHERE` clause of the merge method definition.
`boolean`	`hasWhere()`	Check if the `WHERE` clause exists.
`Merge`	`where(BooleanExpression expression)`	Add a `WHERE` clause `MERGE` definition.

Methods inherited from class com.exasol.sql.AbstractFragment
getRoot

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - where
```
protected WhereClause where
```
    WHERE clause
- Constructor Detail
  - MergeMethodDefinition
```
protected MergeMethodDefinition(Fragment root)
```
    Create the abstract base for a merge method definition.
    
    Parameters:
    
    root - root MERGE statement
- Method Detail
  - where
```
public Merge where(BooleanExpression expression)
```
    Add a WHERE clause MERGE definition.
    
    Parameters:
    
    expression - filter expression
    
    Returns:
    
    parent MERGE statement
  - getWhere
```
public WhereClause getWhere()
```
    Get the WHERE clause of the merge method definition.
    
    Returns:
    
    WHERE clause
  - hasWhere
```
public boolean hasWhere()
```
    Check if the WHERE clause exists.
    
    Returns:
    
    true if the WHERE clause exists