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.
Viewing (ClientNo, PropertyNo, ViewDate, Comment) I already created my table like this: Create table viewing 2 (clien
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Viewing (ClientNo, PropertyNo, ViewDate, Comment) I already created my table like this: Create table viewing 2 (clien
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!