ORA-00904: Invalid identifier, I am creating a table but this error appears, could anyone help me?

Question

CREATE TABLE CARRO(
   ID_CARRO VARCHAR(20),
   MODELO VARCHAR2(10),
   COR VARCHAR2(10),
   PLACA VARCHAR2(10),
   CONSTRAINT PK_CARRO PRIMARY KEY (ID_MARCA, MODELO),
   CONSTRAINT FK_CARRO_REF_MARCA FOREIGN KEY (ID_MARCA)
   REFERENCES MARCA(ID_MARCA),
);

Answer 1

Your query has two errors, I will comment here:

CREATE TABLE CARRO(
   ID_CARRO VARCHAR(20),
   MODELO VARCHAR2(10),
   COR VARCHAR2(10),
   PLACA VARCHAR2(10),
   ID_MARCA INT, <-- Falta esse campo, usado abaixo para criar a FK. Usei INT no exemplo, veja o tipo correto
   CONSTRAINT PK_CARRO PRIMARY KEY (ID_MARCA, MODELO),
   CONSTRAINT FK_CARRO_REF_MARCA FOREIGN KEY (ID_MARCA)
   REFERENCES MARCA(ID_MARCA)  <-- aqui há uma vírgula inválida, remova pois não há mais atributos a serem definidos.
);

• FOREIGN KEY (ID_MARCA) here is creating a FK from a field that has not been defined, need to add earlier in the field list;
• REFERENCES MARCA(ID_MARCA), here is an unnecessary comma, because there is nothing more to define in the table, as the following is the )