Member Avatar for tony75

Hi
Why I got error ?

CREATE TABLE customer_table(
    KNR     INTEGER(10) 
    FN      VARCHAR2(10) NOT NULL,
    EN      VARCHAR2(10) NOT NULL,
    Mobil   NUMBER(10) NOT NULL,
    Tell    INTEGER(10) NOT NULL,


    constraint knr_pk primary key(KNR)

);







Error report -
00907. 00000 -  "missing right parenthesis"
*Cause:    
*Action:
Edited by tony75
  • 2 Contributors
  • 2 Replies
  • 681 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by tony75
Member Avatar for pixelsoul

Most likely because you're missing the comma after the primary key KNR.

CREATE TABLE customer_table
(
    KNR INTEGER(10),
    FN VARCHAR2(10) NOT NULL,
    EN VARCHAR2(10) NOT NULL,
    Mobil NUMBER(10) NOT NULL,
    Tell INTEGER(10) NOT NULL,
    constraint knr_pk primary key (KNR)
);
Member Avatar for tony75

When I add comma or run your code,I still get the same error!!!
As I see the code to create table its not wrong!

Edited by tony75
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.