Answer / jeevan

Pro*C in included in 8i and 9i............Shall I get Pro*C
Compiler in Oracle-10g release ?

what are the database links ?

2 Answers  

---

What is an oracle database table?

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

what is cartesian product?

2 Answers  

---

Can sub procedure/function be called recursively?

0 Answers  

---

What are the varoius components of physical database structure of oracle database?

0 Answers  

---

What is a Temporary Segment ?

2 Answers  

---

What do you mean by merge in oracle?

0 Answers  

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

Describe Referential Integrity ?

1 Answers  

---

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

2 Answers  

---

How to view all columns in an existing table?

0 Answers  

---