Reserved Keywords
A list of reserved keywords that cannot be used in user-defined fields.
The following keywords cannot be used as column names of data models.
MONTH | DAY | YEAR | HOUR |
MIN | SEC | LENGTH | SUBSTR |
SUM | AVG | USE | SUBSTRING |
MID | LOWER | UPPER | TRIM |
SUBSTITUTE | LEFT | RIGHT | FIND |
CONCATENATE | POSITION | SECONDS | MINUTES |
HOURS | DAYS | WEEKS | MONTHS |
YEARS | IIF | TOTIMESTAMP | TOIP |
TOSTRING | TOINT | TOLONG | TOFLOAT |
TOBOOL | EXTRACTJSON | EXTRACTKVP | TOTIMESTAMPSTRING |
INT | LONG | BOOLEAN | DATE |
TIME | STRING | HEX | CASE |
EXPRESSION |
ALL | CHECK | CONSTRAINT | CROSS |
CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP | DISTINCT |
EXCEPT | EXISTS | FALSE | FETCH |
FOR | FOREIGN | FROM | FULL |
GROUP | HAVING | INNER | INTERSECT |
IS | JOIN | LIKE | NULL |
LIMIT | MINUS | NATURAL | NOT |
OFFSET | ON | ORDER | PRIMARY |
ROWNUM | SELECT | SYSDATE | SYSTIME |
SYSTIMESTAMP | TODAY | TRUE | UNION |
UNIQUE | WHERE | WITH |