difference between truncate and delete ,drop?

3 Answers  

---

What is the parameter mode that can be passed to a procedure?

0 Answers  

---

What is a lookup table in oracle?

0 Answers  

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 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  

---

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,

---

How to use regular expression in pattern match conditions in oracle?

0 Answers  

---

What is a schema in oracle?

0 Answers  

---

20. Using a set operator, display the client number of all clients who have never placed an order.

0 Answers   Wipro,

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers   IBM,

---

How to write a query with a left outer join in oracle?

0 Answers  

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

0 Answers  

---