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:

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)
);

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!

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.