Create table Employee
(
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
FirstName varchar2(50),
LastName varchar2(50),
DeptID Number(5)
Constraint dept_id_fk Foreign Key(DeptId)
References Department(DeptId)
)
Error I am getting: Constraint specification are not
allowed here
- 2 Answers
- 5354 Views
- I also Faced
- E-Mail Answers
Answer Posted / durgarao k
Create table Employee
(
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
FirstName varchar2(50),
LastName varchar2(50),
DeptID Number(5),
Constraint dept_id_fk Foreign Key(DeptId)
References Department(DeptId)
)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is merge in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is oracle and what are its different editions?
What is oracle used for?
How to use null as conditions in oracle?
How to retrieve the count of updated rows?
What happens if the update subquery returns multiple rows?
How to convert characters to numbers in oracle?
Explain the blob datatype?
Does oracle partitioning improve performance?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is not equal to in oracle?
What is the difference between a primary key & a unique key?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
what are bitmap indexes? How does they work?
