Help Error 0922

[Dfuga]

Below is what I input into SQL Plus, I cannot determine why I am recieving this error. Any help is appreciated!


SQL> CREATE TABLE
2 Insurance_Info
3 (License_No varchar(20) primary
4 Policy_No varchar(30) alternate
5 Ins_Carrier varchar(50),
6 Ins_Address varchar(50),
7 Ins_City varchar(30),
8 Ins_State varchar(2),
9 Ins_Zip varchar(10),
10 Type_of_Coverag e varchar(30),
11 Years_W_Carrier varchar(10),
12 Amount_Per_Occu r varchar(20),
13 Aggreg_Amount varchar(20),
14 Effective_Date varchar(10),
15 Insur_Exp_Date varchar(10),
16 Claims_Made varchar(10),
17 Prev_Ins_Carrie r varchar(50),
18 Prev_Ins_Carrie r_Address varcha
19 Prev_Ins_Carrie r_City varchar(3
20 Prev_Ins_Carrie r_State varchar(
21 Prev_Ins_Carrie r_Zip varchar(10
22 Prev_Ins_Type_C overage varchar(
23 Prev_Ins_Policy _No varchar(30),
24 Prev_Years_W_Ca rrier varchar(10
25 Prev_Amount_Per _Occur varchar(2
26 Prev_Aggreg_Amo unt varchar(20),
27 Prev_Effective_ Date varchar(10)
28 Prev_Insur_Exp_ Date varchar(10)
29 Prev_Claims_Mad e varchar(10),
30 ADDED_TO_FILE_D ATE varchar(10),
31 ADD_USERID varchar(10),
32 LAST_EDIT_DATE varchar(10))
33
SQL>
SQL> /
(License_No varchar(20) primary key,
*
ERROR at line 3:
ORA-00922: missing or invalid option

[debasisdas]

To whom do you expect to add commas , and closing parenthesis to your code.

silly syntax error.....

[Dfuga]

To whom do you expect to add commas , and closing parenthesis to your code.

silly syntax error.....

What???? if you are saying I need commas after lines 3 and 4, I know, it has them. When I did a cut and paste they just did not appear here, they are in the code in SQL. I am still recieving the error. I will attempt to repost the code as I see other syntax errors.

SQL> CREATE TABLE
2 Insurance_Info
3 (License_No varchar(20) primary key,
4 Policy_No varchar(30) alternate key,
5 Ins_Carrier varchar(50),
6 Ins_Address varchar(50),
7 Ins_City varchar(30),
8 Ins_State varchar(2),
9 Ins_Zip varchar(10),
10 Type_of_Coverag e varchar(30),
11 Years_W_Carrier varchar(10),
12 Amount_Per_Occu r varchar(20),
13 Aggreg_Amount varchar(20),
14 Effective_Date varchar(10),
15 Insur_Exp_Date varchar(10),
16 Claims_Made varchar(10),
17 Prev_Ins_Carrie r varchar(50),
18 Prev_Ins_Carrie r_Address varchar(100),
19 Prev_Ins_Carrie r_City varchar(30),
20 Prev_Ins_Carrie r_State varchar(2),
21 Prev_Ins_Carrie r_Zip varchar(10)
22 Prev_Ins_Type_C overage varchar(50),
23 Prev_Ins_Policy _No varchar(30),
24 Prev_Years_W_Ca rrier varchar(10),
25 Prev_Amount_Per _Occur varchar(20),
26 Prev_Aggreg_Amo unt varchar(20),
27 Prev_Effective_ Date varchar(10),
28 Prev_Insur_Exp_ Date varchar(10),
29 Prev_Claims_Mad e varchar(10),
30 ADDED_TO_FILE_D ATE varchar(10),
31 ADD_USERID varchar(10),
32 LAST_EDIT_DATE varchar(10))
33 /
(License_No varchar(20) primary key,
*
ERROR at line 3:
ORA-00922: missing or invalid option

[debasisdas]

use the following code

create table Insurance_Info
(
License_No varchar(20) primary key,
Policy_No varchar(30) ,
Ins_Carrier varchar(50),
Ins_Address varchar(50),
Ins_City varchar(30),
Ins_State varchar(2),
Ins_Zip varchar(10),
Type_of_Coverage varchar(30),
Years_W_Carrier varchar(10),
Amount_Per_Occur varchar(20),
Aggreg_Amount varchar(20),
Effective_Date varchar(10),
Insur_Exp_Date varchar(10),
Claims_Made varchar(10),
Prev_Ins_Carrier varchar(50),
Prev_Ins_Carrier_Address varchar(100),
Prev_Ins_Carrier_City varchar(30),
Prev_Ins_Carrier_State varchar(2),
Prev_Ins_Carrier_Zip varchar(10),
Prev_Ins_Type_Coverage varchar(50),
Prev_Ins_Policy_No varchar(30),
Prev_Years_W_Carrier varchar(10),
Prev_Amount_Per_Occur varchar(20),
Prev_Aggreg_Amount varchar(20),
Prev_Effective_Date varchar(10),
Prev_Insur_Exp_Date varchar(10),
Prev_Claims_Made varchar(10),
ADDED_TO_FILE_DATE varchar(10),
ADD_USERID varchar(10),
LAST_EDIT_DATE varchar(10)
)
 

what is that alternate key in oracle syntax as specified in your code. ???