Syntax error: Encountered "("

xand · #1 (**permalink**) 02-02-12, 10:57

hi guys,

for example:

CREATE TABLE EMPLOYEE_INPUT (
EMPLOYEE_ID NUMBER(6) NOT NULL,
FIRST_NAME VARCHAR2(20) NULL,
LAST_NAME VARCHAR2(25) NOT NULL,
);

any idea, why it always shows Syntax error: Encountered "(" near NUMBER(6)

(i use 10g XE)

thx

flyboy · #2 (**permalink**) 02-02-12, 11:19

Hi thx,
to be honest, I do not know. Probably you have very creative tool for interacting with Oracle. However it would be helpful, if you posted the exact error with its ORA numeric code (although the one you posted does not look like Oracle one - that "near" word comes from other RDBMS; are you sure it is from Oracle?).
Anyway, in standard Oracle sqlplus, the error is different:

Code:

SQL> CREATE TABLE EMPLOYEE_INPUT (
  2  EMPLOYEE_ID NUMBER(6) NOT NULL,
  3  FIRST_NAME VARCHAR2(20) NULL,
  4  LAST_NAME VARCHAR2(25) NOT NULL,
  5  );
)
*
ERROR at line 5:
ORA-00904: : invalid identifier

Yes, the last comma followed by nothing is the cause.

shammat · #3 (**permalink**) 02-02-12, 12:26

You have a redundant comma after the last NOT NULL statement (before the closing bracket)

xand · #4 (**permalink**) 02-02-12, 15:07

thanks both
I have writen bad sql code for you, lol... that comma after last NULL I hadnt in editor, but error was still there.

I use Netbeans for interacting with Oracle and when I restarted it, code ran.
Now I installed Toad. Or do you know about better software? I'm just learning Oracle and SQL

Littlefoot · #5 (**permalink**) 02-02-12, 15:47

SQL*Plus should be your first choice, until you learn what SQL is and how it works. GUI - yes, but much later.

Internet Services

Web Development

Digital Marketing

Consumer Tech