Keywords

In Oxla, reserved and non-reserved keywords play an important role in SQL syntax and usage. Reserved keywords are strictly defined by the SQL standard and cannot be used as identifiers, such as table or column names, unless explicitly quoted. These keywords have predefined meanings and are always interpreted as part of the SQL syntax, for example, 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
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