adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / durgarao k

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


Please Help Members By Posting Answers For Below Questions

Design database draw er diagram for a certain scenario ?

4656

What is oracle latest version?

1174

How to put more than 1000 values into an oracle in clause?

1115

How to select all columns of all rows from a table in oracle?

1132

How to use values from other tables in update statements using oracle?

1158

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

How to start an oracle instance?

1103

How to write a left outer join with the where clause in oracle?

1155