Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6340 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
How to use "while" statements in oracle?
What happens if the update subquery returns multiple rows?
What is a nested table?
What is truncate oracle?
How to store pictures on to the database?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is the difference between substr & instr functions?
How to delete an existing row from a table in oracle?
What is a cursor variable?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is difference between truncate and delete?
How to shutdown your 10g xe server?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
State all possible different index configurations a table can possibly have?
11. Display the client number and name and the client number and name of the person who referred that client.
