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

Explain cascading triggers.

1121

---

Explain the use of compress option in exp command.

1073

---

How to define a cusotmer as a supplier in ORACLE R12

2305

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2058

---

Can we commit inside a function in oracle?

1014

---

What is the max number of columns in an oracle table?

1048

---

What happens to the indexes if a table is recovered?

1046

---

How to create a new table in your schema?

1130

---

How to download oracle database 10g xe?

1067

---

How is it different from a normal table?

1084

---

What are the built-in functions used for sending Parameters to forms ?

3437

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2341

---

How do we represent comments in oracle?

1098

---

What is java oracle used for?

1076

---

What is a subquery?

1192

---