Search code examples
sqloracle-databaseoracle-sqldevelopercreate-table

Oracle - Error "missing left parenthesis" when CREATE TABLE


I'm using Oracle SQL Developer for learning and implementing SQL Queries. But every time I try to Create Table, it gives an error and I'm not sure what's exactly I'm missing. See the image to see the error:

enter image description here

EDIT:

enter image description here


Solution

  • You can't use the comma sign after the column definition. You can use them if there are multiple columns, but not when only one column. Look the following example -

    Create Table A (
    i int,
    j int
    );
    

    and for one column -

    Create Table A (
    i int
    );