00904. 00000 - "%s: invalid identifier" FOR BEGINNER

CREATE TABLE Pizza (  pizza_id DECIMAL(12) NOT NULL PRIMARY KEY,  name VARCHAR(32) NOT NULL,  date_available DATE NOT NULL,  price DECIMAL(4,2) NOT NULL  );  

CREATE TABLE Topping (  topping_id DECIMAL(12) NOT NULL,  topping_name VARCHAR(64) NOT NULL,  pizza_id DECIMAL(12)  );    ALTER TABLE Topping  ADD CONSTRAINT topping_pk  PRIMARY KEY(topping_id);    ALTER TABLE Topping  ADD CONSTRAINT Topping_pizza_fk  FOREIGN KEY(pizza_id)  REFERENCES Pizza(pizza_id);        INSERT INTO pizza (pizza_id, name, date_avaliable, price)           VALUES (1, 'Plain', CAST('27-Feb-2021' AS DATE), 6.5);  

Error report - SQL Error: ORA-00904: "price": invalid identifier 00904. 00000 - "%s: invalid identifier"

I cannot figure out which part is wrong, im just a beginner for SQL, can someone help me ?

https://stackoverflow.com/questions/66467513/00904-00000-s-invalid-identifier-for-beginner March 04, 2021 at 10:00AM