Answer Posted / durgarao k

There are two ways in specifying constraints
Table level and Column level
In your question you specified Foreign key constraint as column level constraint.so, at that time you write as
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
References Department(DeptId)
)
if you want to specify Foreign key constraint at table level
you just do as
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)
)

What is java oracle used for?

1025

---

What are the oracle differences between nvl and coalesce

1149

---

What is data block in Oracle?

1116

---

What is a table in oracle?

981

---

Can we write insert statement in function in oracle?

1092

---

What is truncate oracle?

971

---

What is oracle datasource?

986

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

---

What are transaction isolation levels supported by oracle?

1072

---

What is sharded cluster?

1015

---

What is translate in oracle?

1100

---

What is archive log in Oracle?

1134

---

How to define a variable of a specific record type?

1078

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078

---

Is oracle an operator?

923

---