Home:ALL Converter>What does this error message mean? ORA-00907: missing right parenthesis

What does this error message mean? ORA-00907: missing right parenthesis

Ask Time:2022-05-17T08:12:09         Author:Maya Strickland

Json Formatter

I am writing my SQL statements in Oracle Application Express and keep getting the error message ORA-00907: missing right parenthesis. Below is the code that I have written to create a table.

CREATE TABLE book
  (
     book_isbn   CHAR(13),
     book_name   VARCHAR(20),
     book_author VARCHAR(20),
     book_pages  CHAR(4),
     book_price  NUM(4, 2),
     PRIMARY KEY(book_isbn)
  ); 

Author:Maya Strickland,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/72266885/what-does-this-error-message-mean-ora-00907-missing-right-parenthesis
yy