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

How can Oracle users be audited?

1053

---

Give syntax for SQL and ORACLE joins.

1037

---

How to get a list of all user accounts in the database?

1029

---

How to convert raw data type into text in oracle? Explain

950

---

What is a package in oracle?

1023

---

What is a cursor and what are the steps need to be taken?

1112

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2144

---

How to find out what oracle odbc drivers are installed?

976

---

What is object data modeling?

903

---

What is java oracle used for?

963

---

What are internal user account in oracle?

946

---

what is IDE,DMV in sql server?

2750

---

Explain an integrity constrains?

1074

---

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?

971

---

How to login to the server without an instance?

1102

---