public enum EPseudoTableType extends Enum<EPseudoTableType>
SQL Server: INSERTED/DELETED in OUTPUT clauses and triggers Oracle/PostgreSQL/MySQL: OLD/NEW in trigger bodies
Example (SQL Server):
UPDATE t SET col = val OUTPUT inserted.col, deleted.col INTO @changes;
| Enum Constant and Description |
|---|
deleted
SQL Server DELETED pseudo table (pre-change values)
|
inserted
SQL Server INSERTED pseudo table (post-change values)
|
new_value
Oracle/PostgreSQL NEW pseudo table (post-change values)
|
none
No pseudo table qualifier
|
old_value
Oracle/PostgreSQL OLD pseudo table (pre-change values)
|
| Modifier and Type | Method and Description |
|---|---|
static EPseudoTableType |
valueOf(String name)
Returns the enum constant of this type with the specified name.
|
static EPseudoTableType[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final EPseudoTableType none
public static final EPseudoTableType inserted
public static final EPseudoTableType deleted
public static final EPseudoTableType old_value
public static final EPseudoTableType new_value
public static EPseudoTableType[] values()
for (EPseudoTableType c : EPseudoTableType.values()) System.out.println(c);
public static EPseudoTableType valueOf(String name)
name - the name of the enum constant to be returned.IllegalArgumentException - if this enum type has no constant with the specified nameNullPointerException - if the argument is null