Datacage: Introduced <dc:virtual-column name="colname" type="type" expr="XPath"> dc:virtual-column can be used to virtual add or replace a column named 'colname' to the current result set. The value is determined by evaluating "XPath", the type is determined by "type" (possible values: number, bool, node, nodeset, string. defaults to string). Usage: <dc:virtual-column name="c" type="number" expr="$a+$b"> <dc:for-each> <dc:message>{$a} + {$b} = {$c}</dc:message> </dc:for-each> </dc:virtual-column> table a | b --+-- 1 | 2 3 | 4 will result in: 1 + 2 = 3 3 + 4 = 7

next.gauge.id = \
    SELECT GAUGES_ID_SEQ.NEXTVAL AS gauge_id FROM DUAL
next.timeinterval.id = \
    SELECT TIME_INTERVALS_ID_SEQ.NEXTVAL AS time_interval_id FROM DUAL
next.discharge.id = \
    SELECT DISCHARGE_TABLES_ID_SEQ.NEXTVAL AS discharge_table_id FROM DUAL
next.discharge.table.values.id = \
    SELECT DISCHARGE_TABLE_VALUES_ID_SEQ.NEXTVAL AS discharge_table_values_id FROM DUAL