Skip Navigation
Expand
Reserved words in Oracle B2C Service
Answer ID 11598   |   Last Review Date 03/29/2021

What are the reserved words in B2C Service?

Environment:

Custom Objects, ROQL. MySQL
Oracle B2C Service, All versions

Resolution:

Reserved words in Oracle B2C Service are those that may not be used in customization queries such as ROQL without an error.  Therefore it is not suggested that those words be used in column names for custom objects or custom fields. 

The list of reserved words is as follows:

ACTION
ADD
ALL
ALTER
ALWAYS
AND
AS
AUTOINCREMENT
BETWEEN
CASE
CHECK
COLLATE
COLUMN
COMMIT
CONSTRAINT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DEFAULT
DEFERRABLE
DELETE
DISTINCT
DO
DROP
ELSE
ESCAPE
EXCEPT
EXCLUDE
EXISTS
FILTER
FIRST
FOLLOWING
FOREIGN
FROM
FULL
GENERATED
GLOB
GROUP
GROUPS
HAVING
IF
IN
INDEX
INDEXED
INNER
INSERT
INTERSECT
INTO
IS
ISNULL
JOIN
LAST
LEFT
LIKE
LIMIT
NATURAL
NO
NOT
NOTHING
NOTNULL
NULL
NULLS
ON
OPERATIONAL
OR
ORDER
OTHERS
OUTER
OVER
PARTITION
PRECEDING
PRIMARY
RANGE
RECURSIVE
REFERENCES
REGEXP
REINDEX
RENAME
REPORT
RIGHT
ROWS
SELECT
SET
TABLE
TEMPORARY
THEN
TIES
TO
TRANSACTION
UNBOUNDED
UNION
UNIQUE
UPDATE
USE
USING
VALUES
WHEN
WHERE
WINDOW
WITH
WITHOUT