ORA-00907: missing right parenthesis

I have been looking at this code for the past two days now and I can not seem to get it to work. It keeps giving me

ORA-00907: missing right parenthesis.

I know that this is a topic that comes up a lot but for some reason none of the examples I have seen has helped me. Can someone please tell me why I got this error and how do I fix it? I am pretty sure that it has nothing to do with my parenthesis, maybe it’s my CONSTRAINTS?

DROP TABLE T_customers CASCADE CONSTRAINTS;
DROP TABLE dvd_collection CASCADE CONSTRAINTS;
DROP TABLE vhs_collection CASCADE CONSTRAINTS;

CREATE TABLE T_customers   (


                           customer_id         VARCHAR2 (8) PRIMARY KEY,
                           last_name           VARCHAR2 (30) NOT NULL,
                           first_name          VARCHAR2 (20) NOT NULL,
                           street             VARCHAR2 (30) NOT NULL,
                           city               VARCHAR2 (30) NOT NULL,
                           state                 CHAR (2) NOT NULL,
                                    CHECK (state IN ('GA','DC','VA','NY')),
                           zip_code           CHAR (5)
                                    CHECK (TO_NUMBER(zip_code)
                              BETWEEN 10000 AND 27999),
                           home_phone         VARCHAR2 (12) UNIQUE,
                           work_phone         VARCHAR2 (12) UNIQUE,
                           email                 VARCHAR2 (95) NOT NULL);




CREATE TABLE historys_T    (

          history_record       VARCHAR2 (8),
          customer_id       VARCHAR2 (8), 
          CONSTRAINT historys_T_FK FOREIGN KEY (customer_id) REFERENCES T_customer
                                       ON DELETE CASCADE,
                           order_id           VARCHAR2 (10) NOT NULL,
                                 CONSTRAINT fk_order_id_orders  
                                       REFERENCES orders
                                       ON DELETE CASCADE);


CREATE TABLE orders     (

                           order_id           VARCHAR2 (10) PRIMARY KEY,
                           m_p_unique_id       VARCHAR2 (10),
                                    CONSTRAINT orders_FK FOREIGN KEY (m_p_unique_id) REFERENCES library (m_p_unique_id)
                           order_date          DATE DEFAULT);



CREATE TABLE library_T     (

                           m_p_unique_id       VARCHAR2 (10)  PRIMARY KEY,
                           movie_title         VARCHAR2 (80)  NOT NULL,
                           serial_number       VARCHAR2 (10)  NOT NULL,
                           movie_id_number   VARCHAR2 (10)  NOT NULL,
                           movie_cast        VARCHAR2 (100) NOT NULL,
                           movie_format    CHAR (3) NOT NULL, 
                                  CONSTRAINT library_FK REFERENCES formats (movie_format));

CREATE TABLE formats_T     (

                           movie_format      CHAR (3) PRIMARY KEY,
                           movie_title       VARCHAR2 (80) NOT NULL,
                           m_p_unique_id     VARCHAR2 (10) NOT NULL,
                                 CONSTRAINT format_FK  REFERENCES library (m_p_unique_id));



CREATE TABLE dvd_collection (      


                           m_p_unique_id       VARCHAR2 (10) NOT NULL,
                           serial_number       VARCHAR2 (10) NOT NULL,
                           movie_id_number  VARCHAR2 (10) NOT NULL,
                           movie_title         VARCHAR2 (80) NOT NULL,
                           movie_cast          VARCHAR2 (100) NOT NULL,
                           movie_format     VARCHAR2 (80) NOT NULL,
                           movie_rating    VARCHAR2 (6) NOT NULL,
                           movie_distributer    VARCHAR2 (30) NOT NULL,
                           movie_price         NUMBER (3,2) NOT NULL,
                           movie_length     NUMBER (3) NOT NULL,
                           movie_award         VARCHAR2 (175) NOT NULL,
                           movie_release       DATE); 


CREATE TABLE vhs_collection            
(

                           m_p_unique_id       VARCHAR2 (10)NOT NULL,
                           serial_number       VARCHAR2 (10) NOT NULL,
                           movie_id_number  VARCHAR2 (10) NOT NULL,
                           movie_title         VARCHAR2 (80) NOT NULL,
                           movie_cast        VARCHAR2 (100) NOT NULL,
                           movie_format    VARCHAR2 (80) NOT NULL,
                           movie_rating    VARCHAR2 (6) NOT NULL,
                           movie_distributer    VARCHAR2 (30) NOT NULL,
                           movie_price         NUMBER (3,2) NOT NULL,
                           movie_length     NUMBER (3) NOT NULL,
                           movie_award         VARCHAR2 (175) NOT NULL,
                           movie_release        DATE);

Here are the results I get when I run the code:

Table dropped.

Table dropped.

Table dropped.

Table created.

                                       ON DELETE CASCADE)
                                       *

ERROR at line 10:
ORA-00907: missing right parenthesis

                           order_date          DATE DEFAULT)
                           *

ERROR at line 6:
ORA-00907: missing right parenthesis

                                  CONSTRAINT library_FK REFERENCES formats (movie_format))
                                                                           *

ERROR at line 9:
ORA-00907: missing right parenthesis

                                 CONSTRAINT format_FK  REFERENCES library (m_p_unique_id))
                                                                          *

ERROR at line 6:
ORA-00907: missing right parenthesis
Table created.

Table created.

Related Posts:

  1. ORA-00904: invalid identifier
  2. how to fix oracle ORA-01722 invalid number error
  3. ORA-00979 not a group by expression
  4. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  5. ORA-01843 not a valid month- Comparing Dates
  6. ORA-00918: column ambiguously defined in SELECT *
  7. Oracle error : ORA-00905: Missing keyword
  8. How do I limit the number of rows returned by an Oracle query after ordering?
  9. Oracle SELECT TOP 10 records
  10. Can a foreign key be NULL and/or duplicate?
  11. How to Select Top 100 rows in Oracle?
  12. ORA-12560: TNS:protocol adaptor error
  13. ORA-00972 identifier is too long alias column name
  14. Oracle Apex column link from LOV values
  15. PLS-00103: Encountered the symbol when expecting one of the following:
  16. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  17. ORA-00918: column ambiguously defined in SELECT *
  18. ORA-00918: column ambiguously defined in SELECT *
  19. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  20. ORA-01861: literal does not match format string
  21. What is it exactly a BLOB in a DBMS context
  22. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  23. How do you create a temporary table in an Oracle database?
  24. Oracle “Partition By” Keyword
  25. How to insert date values into table
  26. Oracle SQL: Update a table with data from another table
  27. SQL selecting rows by most recent date with two unique columns
  28. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  29. Comparing Dates in Oracle SQL
  30. Convert timestamp to date in Oracle SQL
  31. How do I reset a sequence in Oracle?
  32. Update statement with inner join on Oracle
  33. MySQL equivalent of DECODE function in Oracle
  34. Oracle: If Table Exists
  35. DATEDIFF function in Oracle
  36. How to create id with AUTO_INCREMENT on Oracle?
  37. LEFT function in Oracle
  38. What is the difference between Views and Materialized Views in Oracle?
  39. How do I view the Explain Plan in Oracle Sql developer?
  40. ORA-01779: cannot modify a column which maps to a non key-preserved table
  41. ORA-01735: invalid ALTER TABLE option – Toad
  42. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  43. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  44. Case in Select Statement
  45. Self Join to get employee manager name
  46. SQL error “ORA-01722: invalid number”
  47. How can I do an UPDATE statement with JOIN in SQL Server?
  48. Must declare the scalar variable
  49. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  50. IDENTITY_INSERT is set to OFF – How to turn it ON?
  51. How to reset AUTO_INCREMENT in MySQL
  52. What does SQL Select symbol || mean?
  53. Why does NULL = NULL evaluate to false in SQL server
  54. Difference between one-to-many and many-to-one relationship
  55. SQL join on multiple columns in same tables
  56. How do I format date and time on ssrs report?
  57. missing FROM-clause entry for table
  58. How to run a SQL query on an Excel table?
  59. MySQL Error 1264: out of range value for column
  60. How to parse XML data in SQL server table
  61. What is the Oracle equivalent of SQL Server’s IsNull() function?
  62. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  63. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  64. Sql query to insert datetime in SQL Server
  65. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  66. Postgres Error: More than one row returned by a subquery used as an expression
  67. SQL Queries “00904. 00000 – “%s: invalid identifier”
  68. How to divide two columns?
  69. MySQL starts with searching issue
  70. SQL “select where not in subquery” returns no results
  71. ListAGG in SQLSERVER
  72. The used SELECT statements have a different number of columns
  73. using sql count in a case statement
  74. Equivalent of explode() to work with strings in MySQL
  75. How to calculate age (in years) based on Date of Birth and getDate()
  76. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  77. How can I group by date time column without taking time into consideration
  78. Append table to an existing one: SQL Server
  79. How to order by column A and then by column B?
  80. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  81. “select * into table” Will it work for inserting data into existing table
  82. Update query using Subquery in Sql Server
  83. “This SqlTransaction has completed; it is no longer usable.”… configuration error?
  84. register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
  85. prepare() not working
  86. How do I move a WordPress site to another server?
  87. Return number of items in a table with post id
  88. Debugging WordPress
  89. Pull data and display as rows and columns
  90. I need a SQL command to delete specific authors and all posts connected with them
  91. How can i restore only Blogs from a SQL backup file?
  92. DB_HOST – is LOCALHOST speedy than domain name? [closed]
  93. How to change post published date to today date with SQL
  94. Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
  95. how to SELECT meta values that are not null?
  96. blank page after update my theme
  97. Sql query returns empty. But not
  98. SQL – JOIN last child
  99. Adding profile data to database
  100. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date

Leave a Comment