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
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 omit columns with default values in insert statement in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Why does oracle 9i treat an empty string as null?
what is the difference between functional dependecy and multilevel dependency?
Difference between the “verify” and “feedback” command?
Can we insert data in view 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 the exact use of Collections?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
how to do daily transactions with out sql* loader control file regesterd in apps?
how do u setup a replication site?
What is blob datatype?
what happened to the global index when I truncate the data in one of the partition?
How to end the current transaction in oracle?
How can we find out the duplicate values in an oracle table?