SELECT, INSERT and UPDATE.
On the other hand, non-reserved keywords have special meanings only in specific context and can be used as identifiers in other situations. For example, the keyword DB is non-reserved, meaning you can use it directly to name a database.
The table below lists all available keywords that you can use in statements:
Keyword | Oxla Status |
|---|---|
| ABSOLUTE | non-reserved |
| ACTION | non-reserved |
| ADD | non-reserved |
| AFTER | non-reserved |
| AGGREGATE | non-reserved |
| ALL | reserved |
| ALLOCATE | reserved |
| ALTER | non-reserved |
| ANALYSE | reserved |
| ANALYZE | reserved |
| AND | reserved |
| ANY | reserved |
| ANY_VALUE | non-reserved |
| ARE | reserved |
| ARRAY | reserved, requires AS |
| ARRAY_MAX_CARDINALITY | non-reserved |
| AS | reserved, requires AS |
| ASC | reserved |
| ASENSITIVE | non-reserved |
| ASSERTION | non-reserved |
| ASSIGNMENT | non-reserved |
| ASYMMETRIC | reserved |
| AT | non-reserved |
| ATOMIC | non-reserved |
| AUTHORIZATION | reserved (can be function or type) |
| AVG | non-reserved |
| BEFORE | non-reserved |
| BEGIN | non-reserved |
| BEGIN_FRAME | non-reserved |
| BEGIN_PARTITION | non-reserved |
| BETWEEN | non-reserved (cannot be function or type) |
| BIGINT | non-reserved (cannot be function or type) |
| BIT | non-reserved (cannot be function or type) |
| BIT_LENGTH | reserved |
| BLOB | non-reserved |
| BOOL | non-reserved |
| BOOLEAN | non-reserved (cannot be function or type) |
| BOTH | reserved |
| BY | non-reserved |
| CACHE | non-reserved |
| CALL | reserved |
| CALLED | reserved |
| CARDINALITY | non-reserved |
| CASCADE | reserved |
| CASCADED | reserved |
| CASE | reserved |
| CAST | reserved |
| CATALOG | non-reserved |
| CEILING | non-reserved |
| CHAR | non-reserved |
| CHAR_LENGTH | non-reserved |
| CHARACTER | non-reserved |
| CHARACTER_LENGTH | non-reserved |
| CHECK | reserved |
| CLASSIFIER | non-reserved |
| CLOB | non-reserved |
| CLOSE | reserved |
| COALESCE | reserved |
| COLLATE | reserved |
| COLLATION | reserved |
| COLLECT | non-reserved |
| COLUMN | reserved |
| COLUMNS | non-reserved |
| COMMIT | reserved |
| CONDITION | reserved |
| CONNECT | reserved |
| CONNECTION | reserved |
| CONSTRAINT | reserved |
| CONSTRAINTS | non-reserved |
| CONTAINS | non-reserved |
| CONTINUE | reserved |
| CONTROL | non-reserved |
| CONVERT | non-reserved |
| COPY | non-reserved |
| CORR | non-reserved |
| CORRESPONDING | reserved |
| COVAR_POP | non-reserved |
| COVAR_SAMP | non-reserved |
| CREATE | reserved |
| CROSS | reserved |
| CUBE | reserved |
| CUME_DIST | non-reserved |
| CURRENT | reserved |
| CURRENT_USER | reserved |
| CURRENT_ROLE | reserved |
| CURSOR | reserved |
| CYCLE | reserved |
| DATABASE | non-reserved |
| DATABASES | non-reserved |
| DATALINK | non-reserved |
| DATE | non-reserved |
| DATETIME | non-reserved |
| DAY | non-reserved |
| DEALLOCATE | reserved |
| DEC | non-reserved |
| DECFLOAT | non-reserved |
| DECIMAL | non-reserved |
| DECLARE | reserved |
| DEFAULT | reserved |
| DEFERRABLE | reserved |
| DEFERRED | reserved |
| DEFINE | non-reserved |
| DELETE | reserved |
| DELTA | non-reserved |
| DENSE_RANK | non-reserved |
| DEREF | non-reserved |
| DESC | reserved |
| DESCRIBE | reserved |
| DESCRIPTOR | reserved |
| DETERMINISTIC | reserved |
| DIAGNOSTICS | reserved |
| DIRECT | non-reserved |
| DISCONNECT | reserved |
| DISTINCT | reserved |
| DLNEWCOPY | non-reserved |
| DLPREVIOUSCOPY | non-reserved |
| DLURLCOMPLETE | non-reserved |
| DLURLCOMPLETEONLY | non-reserved |
| DLURLCOMPLETEWRITE | non-reserved |
| DLURLPATH | non-reserved |
| DLURLPATHONLY | non-reserved |
| DLURLPATHWRITE | non-reserved |
| DLURLSCHEME | non-reserved |
| DLURLSERVER | non-reserved |
| DLVALUE | non-reserved |
| DO | reserved |
| DOMAIN | non-reserved |
| DOUBLE | non-reserved |
| DROP | reserved |
| DYNAMIC | non-reserved |
| EACH | reserved |
| ELEMENT | non-reserved |
| ELSE | reserved |
| EMPTY | non-reserved |
| END | reserved |
| END_FRAME | non-reserved |
| END_PARTITION | non-reserved |
| EQUALS | non-reserved |
| ESCAPE | reserved |
| EVERY | reserved |
| EXCEPT | reserved |
| EXCEPTION | reserved |
| EXEC | reserved |
| EXECUTE | reserved |
| EXISTS | reserved |
| EXP | non-reserved |
| EXPLAIN | reserved |
| EXTERNAL | reserved |
| EXTRACT | reserved |
| FALSE | reserved |
| FETCH | reserved |
| FILE | non-reserved |
| FILTER | reserved |
| FIRST | reserved |
| FIRST_VALUE | non-reserved |
| FLOAT | non-reserved |
| FLOOR | non-reserved |
| FOR | reserved |
| FOREIGN | reserved |
| FORMAT | non-reserved |
| FOUND | non-reserved |
| FRAME_ROW | non-reserved |
| FREE | non-reserved |
| FROM | reserved |
| FULL | reserved |
| FUNCTION | reserved |
| FUSION | non-reserved |
| GET | non-reserved |
| GLOBAL | reserved |
| GO | non-reserved |
| GOTO | non-reserved |
| GRANT | reserved |
| GROUP | reserved |
| GROUPING | reserved |
| GROUPS | non-reserved |
| HASH | non-reserved |
| HAVING | reserved |
| HINT | non-reserved |
| HOLD | non-reserved |
| HOUR | non-reserved |
| IDENTITY | reserved |
| IF | reserved |
| ILIKE | non-reserved |
| IMMEDIATE | reserved |
| IMPORT | non-reserved |
| IN | reserved |
| INDEX | reserved |
| INDICATOR | reserved |
| INITIAL | reserved |
| INITIALLY | reserved |
| INNER | reserved |
| INOUT | reserved |
| INPUT | reserved |
| INSENSITIVE | reserved |
| INSERT | reserved |
| INT | non-reserved |
| INTEGER | non-reserved |
| INTERSECT | reserved |
| INTERSECTION | non-reserved |
| INTERVAL | reserved |
| INTO | reserved |
| IS | reserved |
| ISNULL | non-reserved |
| ISOLATION | reserved |
| JOIN | reserved |
| JSON | non-reserved |
| JSON_ARRAY | non-reserved |
| JSON_ARRAYAGG | non-reserved |
| JSON_EXISTS | non-reserved |
| JSON_OBJECT | non-reserved |
| JSON_OBJECTAGG | non-reserved |
| JSON_QUERY | non-reserved |
| JSON_TABLE | non-reserved |
| JSON_TABLE_PRIMITIVE | non-reserved |
| JSON_VALUE | non-reserved |
| JSONB | non-reserved |
| KEY | non-reserved |
| LAG | non-reserved |
| LANGUAGE | reserved |
| LARGE | non-reserved |
| LAST | reserved |
| LAST_VALUE | non-reserved |
| LATERAL | reserved |
| LEAD | non-reserved |
| LEADING | reserved |
| LEFT | reserved |
| LEVEL | non-reserved |
| LIKE | reserved |
| LIKE_REGEX | non-reserved |
| LIMIT | reserved |
| LISTAGG | non-reserved |
| LN | non-reserved |
| LOAD | non-reserved |
| LOCAL | reserved |
| LOCALTIME | reserved |
| LOCALTIMESTAMP | reserved |
| LONG | non-reserved |
| MEASURES | non-reserved |
| MEMBER | non-reserved |
| MERGE | reserved |
| METHOD | non-reserved |
| MINUS | reserved |
| MINUTE | non-reserved |
| MODIFIES | reserved |
| MODULE | non-reserved |
| MONTH | non-reserved |
| MULTISET | non-reserved |
| NAMES | non-reserved |
| NATIONAL | non-reserved |
| NATURAL | reserved |
| NCHAR | non-reserved |
| NCLOB | non-reserved |
| NEW | reserved |
| NEXT | non-reserved |
| NO | reserved |
| NONE | non-reserved |
| NOT | reserved |
| NTILE | non-reserved |
| NULL | reserved |
| NULLIF | reserved |
| NULLS | reserved |
| NVARCHAR | non-reserved |
| OCCURRENCES_REGEX | non-reserved |
| OCTET_LENGTH | non-reserved |
| OF | reserved |
| OFF | non-reserved |
| OFFSET | reserved |
| OLD | reserved |
| OMIT | non-reserved |
| ON | reserved |
| ONE | non-reserved |
| ONLY | reserved |
| OPEN | reserved |
| OPTION | reserved |
| OR | reserved |
| ORDER | reserved |
| OUT | reserved |
| OUTER | reserved |
| OUTPUT | reserved |
| OVER | reserved |
| OVERLAPS | reserved |
| OVERLAY | non-reserved |
| PAD | non-reserved |
| PARAMETER | reserved |
| PARAMETERS | non-reserved |
| PARTIAL | reserved |
| PARTITION | reserved |
| PATTERN | non-reserved |
| PER | non-reserved |
| PERCENT | non-reserved |
| PERCENT_RANK | non-reserved |
| PERCENTILE_CONT | non-reserved |
| PERCENTILE_DISC | non-reserved |
| PERIOD | reserved |
| PERMUTE | non-reserved |
| PLACING | non-reserved |
| PLAN | non-reserved |
| PORTION | non-reserved |
| PRECEDES | non-reserved |
| PRECISION | reserved |
| PREPARE | reserved |
| PRESERVE | reserved |
| PRIMARY | reserved |
| PRIOR | reserved |
| PRIVILEGES | non-reserved |
| PROCEDURE | reserved |
| PTF | non-reserved |
| PUBLIC | reserved |
| RANGE | reserved |
| READ | reserved |
| READS | reserved |
| REAL | non-reserved |
| RECURSIVE | reserved |
| REF | reserved |
| REFERENCES | reserved |
| REFERENCING | reserved |
| REGR_AVGX | non-reserved |
| REGR_AVGY | non-reserved |
| REGR_COUNT | non-reserved |
| REGR_INTERCEPT | non-reserved |
| REGR_R2 | non-reserved |
| REGR_SLOPE | non-reserved |
| REGR_SXX | non-reserved |
| REGR_SXY | non-reserved |
| REGR_SYY | non-reserved |
| RELATIVE | non-reserved |
| RELEASE | reserved |
| RENAME | reserved |
| RESTRICT | reserved |
| RESULT | reserved |
| RETURN | reserved |
| RETURNS | reserved |
| REVOKE | reserved |
| RIGHT | reserved |
| ROLLBACK | reserved |
| ROLLUP | reserved |
| ROW | reserved |
| ROW_NUMBER | non-reserved |
| ROWS | reserved |
| RUNNING | non-reserved |
| SAVEPOINT | reserved |
| SCHEMA | reserved |
| SCHEMAS | non-reserved |
| SCOPE | reserved |
| SCROLL | reserved |
| SEARCH | non-reserved |
| SECOND | non-reserved |
| SECTION | non-reserved |
| SEEK | non-reserved |
| SELECT | reserved |
| SENSITIVE | reserved |
| SESSION | reserved |
| SESSION_USER | reserved |
| SET | reserved |
| SHOW | non-reserved |
| SIMILAR | non-reserved |
| SIZE | non-reserved |
| SKIP | non-reserved |
| SMALLINT | non-reserved |
| SOME | reserved |
| SORTED | non-reserved |
| SPACE | non-reserved |
| SPATIAL | non-reserved |
| SPECIFIC | reserved |
| SPECIFICTYPE | non-reserved |
| SQL | reserved |
| SQLCODE | non-reserved |
| SQLERROR | non-reserved |
| SQLEXCEPTION | non-reserved |
| SQLSTATE | non-reserved |
| SQLWARNING | non-reserved |
| START | reserved |
| STATIC | reserved |
| STDDEV_POP | non-reserved |
| STDDEV_SAMP | non-reserved |
| STRING | non-reserved |
| SUBMULTISET | non-reserved |
| SUBSET | non-reserved |
| SUCCEEDS | non-reserved |
| SYMMETRIC | reserved |
| SYSTEM | reserved |
| SYSTEM_TIME | non-reserved |
| SYSTEM_USER | reserved |
| TABLE | reserved |
| TABLES | non-reserved |
| TABLESAMPLE | reserved |
| TEMPORARY | reserved |
| TEXT | non-reserved |
| THEN | reserved |
| TIME | non-reserved |
| TIMESTAMP | non-reserved |
| TIMESTAMP_TRUNC | non-reserved |
| TO | reserved |
| TOP | non-reserved |
| TRAILING | reserved |
| TRANSACTION | reserved |
| TRANSLATE | reserved |
| TRANSLATE_REGEX | non-reserved |
| TRANSLATION | non-reserved |
| TREAT | reserved |
| TRIGGER | reserved |
| TRUE | reserved |
| TRUNCATE | reserved |
| UESCAPE | reserved |
| UNION | reserved |
| UNIQUE | reserved |
| UNKNOWN | reserved |
| UNLOAD | non-reserved |
| UNMATCHED | non-reserved |
| UNNEST | non-reserved |
| UPDATE | reserved |
| UPPER | non-reserved |
| USAGE | reserved |
| USER | non-reserved |
| USING | reserved |
| VALUES | reserved |
| VAR_POP | non-reserved |
| VAR_SAMP | non-reserved |
| VARBINARY | non-reserved |
| VARCHAR | non-reserved |
| VARIADIC | reserved |
| VARYING | reserved |
| VERSIONING | non-reserved |
| VIEW | reserved |
| VIRTUAL | non-reserved |
| WHEN | reserved |
| WHENEVER | reserved |
| WHERE | reserved |
| WIDTH_BUCKET | non-reserved |
| WINDOW | reserved |
| WITH | reserved |
| WITHIN | reserved |
| WITHOUT | reserved |
| WORK | reserved |
| WRITE | non-reserved |
| XML | non-reserved |
| XMLAGG | non-reserved |
| XMLATTRIBUTES | non-reserved |
| XMLBINARY | non-reserved |
| XMLCAST | non-reserved |
| XMLCOMMENT | non-reserved |
| XMLCONCAT | non-reserved |
| XMLDOCUMENT | non-reserved |
| XMLELEMENT | non-reserved |
| XMLEXISTS | non-reserved |
| XMLFOREST | non-reserved |
| XMLITERATE | non-reserved |
| XMLNAMESPACES | non-reserved |
| XMLPARSE | non-reserved |
| XMLPI | non-reserved |
| XMLQUERY | non-reserved |
| XMLSERIALIZE | non-reserved |
| XMLTABLE | non-reserved |
| XMLTEXT | non-reserved |
| XMLVALIDATE | non-reserved |
| YEAR | non-reserved |
| ZONE | non-reserved |