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:
Jump to PostMost 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) );
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!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.