ORA-00917 missing comma

I got ” ORA-00917 missing comma ”  error in Oracle database.

ORA-00917 missing comma

Details of error are as follows.

ORA-00917 missing comma

Cause: A required comma has been omitted from a list of columns or values in an INSERT statement or a list of the form ((C,D),(E,F), ...).

Action: Correct the syntax

missing comma

This ORA-00917 error is related with the required comma has been omitted from a list of columns or values in an INSERT statement or a list of the form ((C,D),(E,F), …).

To solve this error, Correct the syntax

Don’t forget using comma.

Sometimes  there is a missing ) at the end of Insert, you should add if one of ) is missing.

Do you want to learn Oracle Database for Beginners, then read the following articles.