waht is referencial integrity?

2 Answers   Semantic Space,

---

what is primary key?

9 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

4 Answers   Thermotech,

---

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,

---

What is the difference between alert log file and tarce file ?

0 Answers   TCS,

---

What are temporal data types in oracle?

0 Answers  

---

Explain the difference between a procedure and a function?

0 Answers  

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

What is the string concatenation operator in oracle?

0 Answers  

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---