Viewing (ClientNo, PropertyNo, ViewDate, Comment) I already created my table like this: Create table viewing 2 (clien
Posted: Fri May 06, 2022 6:14 am
Viewing (ClientNo, PropertyNo, ViewDate, Comment)
I already created my table like this:
Create table viewing
2 (clientNo char(4) not null,
3 propertyNo char(4) not null,
4 viewdate date not null,
5 comment char(15),
6 constraint viewpk primary key (clientNo,
viewdate),
7 constraint clientfk foreign key (clientNO)
references client (clientNo),
8 constraint propertyfk foreign key (propertyNo)
references Property (propertyNo));
comment char(15),
*
ERROR at line 5:
ORA-00904: : invalid identifier
It's saying that there was an error at line 5.
I already created my table like this:
Create table viewing
2 (clientNo char(4) not null,
3 propertyNo char(4) not null,
4 viewdate date not null,
5 comment char(15),
6 constraint viewpk primary key (clientNo,
viewdate),
7 constraint clientfk foreign key (clientNO)
references client (clientNo),
8 constraint propertyfk foreign key (propertyNo)
references Property (propertyNo));
comment char(15),
*
ERROR at line 5:
ORA-00904: : invalid identifier
It's saying that there was an error at line 5.