Viewing (ClientNo, PropertyNo, ViewDate, Comment) I already created my table like this: Create table viewing 2 (clien

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
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

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply