Keyword should be avoided as a Name

Using regular keywords as name can be confusing and should be avoided.

Violating this rule will affect the maintainability of the code.The severity is major which means that it should be corrected.

Example of Incorrect Code:

Regular keyword Delete is used as a function name.

PROCEDURE Delete (
        company_ IN VARCHAR2,
        authorize_id_ IN VARCHAR2 )  
...

Alternative to Delete could for example be Remove.

PROCEDURE Remove (
        company_ IN VARCHAR2,
        authorize_id_ IN VARCHAR2 )  
...

Appendix 1: SQL keywords

• SELECT
• INSERT
• UPDATE
• DELETE

Appendix 2: PL/SQL reserved words

• ALL
• ALTER
• AND
• ANY
• AS
• ASC
• AT
• BEGIN
• BETWEEN
• BY
• CASE
• CHECK
• CLUSTER
• CLUSTERS
• COLAUTH
• COLUMNS
• COMPRESS
• CONNECT
• CRASH
• CREATE
• CURRENT
• DECLARE
• DEFAULT
• DELETE
• DESC
• DISTINCT
• DROP
• ELSE
• END
• EXCEPTION
• EXCLUSIVE
• FETCH
• FOR
• FROM
• GOTO
• GRANT
• GROUP
• HAVING
• IDENTIFIED
• IF
• IN
• INDEX
• INDEXES
• INSERT
• INTERSECT
• INTO
• IS
• LIKE
• LOCK
• MINUS
• MODE
• NOCOMPRESS
• NOT
• NOWAIT
• NULL
• OF
• ON
• OPTION
• OR
• ORDER
• OVERLAPS
• PRIOR
• PROCEDURE
• PUBLIC
• RESOURCE
• REVOKE
• SELECT
• SHARE
• SIZE
• SQL
• START
• SUBTYPE
• TABAUTH
• TABLE
• THEN
• TO
• TYPE
• UNION
• UNIQUE
• UPDATE
• VALUES
• VIEW
• VIEWS
• WHEN
• WHERE
• WITH

This page is generated from IFS Developer Studio at 2021-08-13 08:40.