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
6298 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

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1056

What is sharded cluster?

924

What privilege is needed for a user to create views in oracle?

978

Explain cascading triggers.

1011

Explain about integrity constraint?

1077

What happens to the indexes if a table is recovered?

941

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

972

What is the purpose of tables, private synonyms and public synonyms in Oracle?

977

What is a connect identifier?

982

How to count duplicated values in a column in oracle?

982

Give the various rollback segment states.

999

What are the attributes of the cursor?

934

How to execute the package in oracle?

1036

Explain how are indexes update?

1014

How many types of segments in Oracle?

1012