Is COMMENT a reserved word in Oracle? If so, how can I name a field in a table 'COMMENT'?

    Requires Free Membership to View

As you can see below, COMMENT is a reserved word in Oracle.
SQL> select keyword from v$reserved_words
  2  where keyword = 'COMMENT';

KEYWORD
----------------------------------------------------------------
COMMENT
I would seriously reconsider trying to create a table with a column name that is a reserved word. Any reason why this column can't be called COMMENTS or USER_COMMENTS?

This was first published in September 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.