CODEWITHSUNDEEP
sqloracle-database
Lenin Kumam
Lenin Kumam

Reputation: 11

when I create table, I got this error ORA-00904: : invalid identifier

When I create the table, I got this error ORA-00904: : invalid identifier, I don't know what the error means.

Create table c_stock(s_date date not null,
                     o_stock number(4),
                     add number(4),
                     total number(4));

Upvotes: 0

Views: 3548

Answers (1)

dsn084
dsn084

Reputation: 88

From the ORA-00904 description:

ORA-00904 string: invalid identifier

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter,be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.

Looking at the list of Oracle reserved words, ADD appears on the second row.

Changing that column name should resolve your problem.

Upvotes: 5

Related Questions