create table sl_rep_winners(
slnum INT (12),
zone INT,
city nvarchar(200),
county nvarchar(200),
town nvarchar(200)
);
I get a "missing right parenthesis" error. What is the reason of error?
Asked
Active
Viewed 106 times
1
-
what is your dbms - oracle or mysql? – Fahmi Dec 07 '18 at 06:51
-
1Your SQL code runs fine on mySQL. The source of your problem might be somewhere else. – FloT Dec 07 '18 at 06:53
-
Oracle: use nvarchar2() (not: nvarchar) – stefan Dec 07 '18 at 06:59
-
@a_horse_with_no_name when I wrote my comment the post was tagged with both mySQL and Oracle. It has been edited then by Mat, but are we sure that Gokce Ezeroglu indeed uses Oracle? – FloT Dec 07 '18 at 07:39
1 Answers
1
If you are using Oracle:
create table sl_rep_winners
(
slnum number(12),
zone number(10),
city varchar2(200),
county varchar2(200),
town varchar2(200)
);
INTEGER is supported as an ANSI datatype but gets converted to the equivalent Oracle datatype which is number().
FYI: nvarchar & varchar2
Georgy
- 428
- 2
- 16
-
1It might be worth noting that `number(12)` supports a maximum value of `999999999999` which is much larger than the maximum value supported by MySQL's `int` data type. – Dec 07 '18 at 07:31