[Ace1stCav]

Hey guys...I'm having some trouble figuring out why I can't create a simple Oracle10g table. I've tried all different spacing and syntax, but I keep getting the same error ( ERROR at line 1: missing right parenthesis).I know its not case sensitive etc...I've gone over this a thousand different ways. I'm sure it's something completely simple too. Can you guys please provide some feedback?

SQL> CREATE TABLE customers(acct_id VARCHAR2(10)PRIMARYKEY,
  2  name VARCHAR2(30)NOTNULL,
  3  zip_code CHAR(5)UNIQUE);
CREATE TABLE customers(acct_id VARCHAR2(10)PRIMARYKEY,
                                           *
ERROR at line 1:
ORA-00907: missing right parenthesis

[Nidhesh]

Please remove the 4rth line from your code. It's a repeat of the first line.
If you were trying to add a primary constraint to the first column, you have already done that using PRIMARYKEY keyword in the first colum.
Rest look ok.