- Sql Worksheet T 1 Create Table Registration 2 Clientno Varchar 4 3 Branchno Varchar A 4 Staffno Varchar 5 Datejoine 1 (23.82 KiB) Viewed 36 times
SQL Worksheet t 1 Create table REGISTRATION 2 CLIENTNO VARCHAR(4), 3 BRANCHNO VARCHAR(A), 4 STAFFNO VARCHAR, 5 DATEJOINE
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
SQL Worksheet t 1 Create table REGISTRATION 2 CLIENTNO VARCHAR(4), 3 BRANCHNO VARCHAR(A), 4 STAFFNO VARCHAR, 5 DATEJOINE
SQL Worksheet t 1 Create table REGISTRATION 2 CLIENTNO VARCHAR(4), 3 BRANCHNO VARCHAR(A), 4 STAFFNO VARCHAR, 5 DATEJOINED DATE; 6 PRIMARY KEY(CLIENTNO), 7 FOREIGN KEY(CLIENTNO) references Client(CLIENTNO), 8 FOREIGN KEY(BRANCHNO) references Brach(BRANCHNO), 9 FOREIGN KEY(STAFFNO) references Staff (STAFFNO) 10); ORA-009061 missing left parenthesis
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!