Create table Employee ( Employee_Id varchar2(8) Constraint emp_id

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

2 Answers
6511 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

Please Help Members By Posting Answers For Below Questions

Explain what are the different type of segments?

1003

What are temporal data types in oracle?

1171

How many categories of data types?

1043

Which is better Oracle or MS SQL? Why?

6486

How to use subqueries with the exists operator in oracle?

1071

Can we create trigger on materialized view in oracle?

1045

What is format trigger?

2121

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2038

How to export data to a csv file?

1385

How to shutdown your 10g xe server from command line?

1154

What are the tools for Oracle ?

1112

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2365

What is transport network substrate (tns) in oracle?

1096

How to retrieve values from data fields in record variables?

1173

How to set up autotrace for a user account?

1112